text: Search.setIndex({envversion:47,filenames:["admin","admin/queue","admin/resource-groups","admin/tuning","admin/web-interface","connector","connector/accumulo","connector/blackhole","connector/cassandra","connector/hive","connector/hive-security","connector/jmx","connector/kafka","connector/kafka-tutorial","connector/localfile","connector/mongodb","connector/mysql","connector/postgresql","connector/redis","connector/system","connector/tpch","develop","develop/connectors","develop/event-listener","develop/example-http","develop/functions","develop/spi-overview","develop/system-access-control","develop/types","functions","functions/aggregate","functions/array","functions/binary","functions/bitwise","functions/color","functions/comparison","functions/conditional","functions/conversion","functions/datetime","functions/decimal","functions/json","functions/logical","functions/map","functions/math","functions/regexp","functions/string","functions/teradata","functions/url","functions/window","index","installation","installation/benchmark-driver","installation/cli","installation/deployment","installation/jdbc","installation/tableau","installation/verifier","language","language/types","migration","migration/from-hive","overview","overview/use-cases","release","release/release-0.100","release/release-0.101","release/release-0.102","release/release-0.103","release/release-0.104","release/release-0.105","release/release-0.106","release/release-0.107","release/release-0.108","release/release-0.109","release/release-0.110","release/release-0.111","release/release-0.112","release/release-0.113","release/release-0.114","release/release-0.115","release/release-0.116","release/release-0.117","release/release-0.118","release/release-0.119","release/release-0.120","release/release-0.121","release/release-0.122","release/release-0.123","release/release-0.124","release/release-0.125","release/release-0.126","release/release-0.127","release/release-0.128","release/release-0.129","release/release-0.130","release/release-0.131","release/release-0.132","release/release-0.133","release/release-0.134","release/release-0.135","release/release-0.136","release/release-0.137","release/release-0.138","release/release-0.139","release/release-0.140","release/release-0.141","release/release-0.142","release/release-0.143","release/release-0.144","release/release-0.144.1","release/release-0.144.2","release/release-0.144.3","release/release-0.144.4","release/release-0.144.5","release/release-0.144.6","release/release-0.144.7","release/release-0.145","release/release-0.146","release/release-0.147","release/release-0.148","release/release-0.149","release/release-0.150","release/release-0.151","release/release-0.152","release/release-0.152.1","release/release-0.152.2","release/release-0.152.3","release/release-0.153","release/release-0.154","release/release-0.155","release/release-0.156","release/release-0.157","release/release-0.54","release/release-0.55","release/release-0.56","release/release-0.57","release/release-0.58","release/release-0.59","release/release-0.60","release/release-0.61","release/release-0.62","release/release-0.63","release/release-0.64","release/release-0.65","release/release-0.66","release/release-0.67","release/release-0.68","release/release-0.69","release/release-0.70","release/release-0.71","release/release-0.72","release/release-0.73","release/release-0.74","release/release-0.75","release/release-0.76","release/release-0.77","release/release-0.78","release/release-0.79","release/release-0.80","release/release-0.81","release/release-0.82","release/release-0.83","release/release-0.84","release/release-0.85","release/release-0.86","release/release-0.87","release/release-0.88","release/release-0.89","release/release-0.90","release/release-0.91","release/release-0.92","release/release-0.93","release/release-0.94","release/release-0.95","release/release-0.96","release/release-0.97","release/release-0.98","release/release-0.99","security","security/cli","security/server","sql","sql/alter-schema","sql/alter-table","sql/call","sql/commit","sql/create-schema","sql/create-table","sql/create-table-as","sql/create-view","sql/delete","sql/describe","sql/drop-schema","sql/drop-table","sql/drop-view","sql/explain","sql/explain-analyze","sql/grant","sql/insert","sql/reset-session","sql/revoke","sql/rollback","sql/select","sql/set-session","sql/show-catalogs","sql/show-columns","sql/show-create-table","sql/show-create-view","sql/show-functions","sql/show-partitions","sql/show-schemas","sql/show-session","sql/show-tables","sql/start-transaction","sql/use","sql/values"],objects:{"":{"typeof":[37,0,1,""],abs:[43,0,1,""],acos:[43,0,1,""],approx_distinct:[30,0,1,""],approx_percentile:[30,0,1,""],arbitrary:[30,0,1,""],array_agg:[30,0,1,""],array_distinct:[31,0,1,""],array_intersect:[31,0,1,""],array_join:[31,0,1,""],array_max:[31,0,1,""],array_min:[31,0,1,""],array_position:[31,0,1,""],array_remove:[31,0,1,""],array_sort:[31,0,1,""],array_union:[31,0,1,""],asin:[43,0,1,""],atan2:[43,0,1,""],atan:[43,0,1,""],avg:[30,0,1,""],bar:[34,0,1,""],bit_count:[33,0,1,""],bitwise_and:[33,0,1,""],bitwise_and_agg:[30,0,1,""],bitwise_not:[33,0,1,""],bitwise_or:[33,0,1,""],bitwise_or_agg:[30,0,1,""],bitwise_xor:[33,0,1,""],bool_and:[30,0,1,""],bool_or:[30,0,1,""],cardinality:[31,0,1,""],cast:[37,0,1,""],cbrt:[43,0,1,""],ceil:[43,0,1,""],ceiling:[43,0,1,""],char2hexint:[46,0,1,""],checksum:[30,0,1,""],chr:[45,0,1,""],color:[34,0,1,""],concat:[45,0,1,""],contains:[31,0,1,""],corr:[30,0,1,""],cos:[43,0,1,""],cosh:[43,0,1,""],cosine_similarity:[43,0,1,""],count:[30,0,1,""],count_if:[30,0,1,""],covar_pop:[30,0,1,""],covar_samp:[30,0,1,""],cume_dist:[48,0,1,""],current_timezone:[38,0,1,""],date_add:[38,0,1,""],date_diff:[38,0,1,""],date_format:[38,0,1,""],date_parse:[38,0,1,""],date_trunc:[38,0,1,""],day:[38,0,1,""],day_of_month:[38,0,1,""],day_of_week:[38,0,1,""],day_of_year:[38,0,1,""],degrees:[43,0,1,""],dense_rank:[48,0,1,""],dow:[38,0,1,""],doy:[38,0,1,""],e:[43,0,1,""],element_at:[31,0,1,""],every:[30,0,1,""],exp:[43,0,1,""],extract:[38,0,1,""],first_value:[48,0,1,""],flatten:[31,0,1,""],floor:[43,0,1,""],format_datetime:[38,0,1,""],from_base64:[32,0,1,""],from_base64url:[32,0,1,""],from_base:[43,0,1,""],from_hex:[32,0,1,""],from_iso8601_date:[38,0,1,""],from_iso8601_timestamp:[38,0,1,""],from_unixtime:[38,0,1,""],from_utf8:[45,0,1,""],geometric_mean:[30,0,1,""],greatest:[35,0,1,""],histogram:[30,0,1,""],hour:[38,0,1,""],index:[46,0,1,""],infinity:[43,0,1,""],is_finite:[43,0,1,""],is_infinite:[43,0,1,""],is_nan:[43,0,1,""],json_array_contains:[40,0,1,""],json_array_get:[40,0,1,""],json_array_length:[40,0,1,""],json_extract:[40,0,1,""],json_extract_scalar:[40,0,1,""],json_format:[40,0,1,""],json_parse:[40,0,1,""],json_size:[40,0,1,""],lag:[48,0,1,""],last_value:[48,0,1,""],lead:[48,0,1,""],least:[35,0,1,""],length:[45,0,1,""],ln:[43,0,1,""],log10:[43,0,1,""],log2:[43,0,1,""],log:[43,0,1,""],lower:[45,0,1,""],lpad:[45,0,1,""],ltrim:[45,0,1,""],map:[42,0,1,""],map_agg:[30,0,1,""],map_concat:[42,0,1,""],map_keys:[42,0,1,""],map_union:[30,0,1,""],map_values:[42,0,1,""],max:[30,0,1,""],max_by:[30,0,1,""],md5:[32,0,1,""],min:[30,0,1,""],min_by:[30,0,1,""],minute:[38,0,1,""],mod:[43,0,1,""],month:[38,0,1,""],multimap_agg:[30,0,1,""],nan:[43,0,1,""],normalize:[45,0,1,""],now:[38,0,1,""],nth_value:[48,0,1,""],ntile:[48,0,1,""],numeric_histogram:[30,0,1,""],parse_datetime:[38,0,1,""],percent_rank:[48,0,1,""],pi:[43,0,1,""],position:[45,0,1,""],pow:[43,0,1,""],power:[43,0,1,""],quarter:[38,0,1,""],radians:[43,0,1,""],rand:[43,0,1,""],random:[43,0,1,""],rank:[48,0,1,""],regexp_extract:[44,0,1,""],regexp_extract_all:[44,0,1,""],regexp_like:[44,0,1,""],regexp_replace:[44,0,1,""],regexp_split:[44,0,1,""],regr_intercept:[30,0,1,""],regr_slope:[30,0,1,""],render:[34,0,1,""],replace:[45,0,1,""],reverse:[45,0,1,""],rgb:[34,0,1,""],round:[43,0,1,""],row_number:[48,0,1,""],rpad:[45,0,1,""],rtrim:[45,0,1,""],second:[38,0,1,""],sequence:[31,0,1,""],sha1:[32,0,1,""],sha256:[32,0,1,""],sha512:[32,0,1,""],shuffle:[31,0,1,""],sign:[43,0,1,""],sin:[43,0,1,""],slice:[31,0,1,""],split:[45,0,1,""],split_part:[45,0,1,""],split_to_map:[45,0,1,""],sqrt:[43,0,1,""],stddev:[30,0,1,""],stddev_pop:[30,0,1,""],stddev_samp:[30,0,1,""],strpos:[45,0,1,""],substr:[45,0,1,""],substring:[46,0,1,""],sum:[30,0,1,""],tan:[43,0,1,""],tanh:[43,0,1,""],timezone_hour:[38,0,1,""],timezone_minute:[38,0,1,""],to_base64:[32,0,1,""],to_base64url:[32,0,1,""],to_base:[43,0,1,""],to_char:[46,0,1,""],to_date:[46,0,1,""],to_hex:[32,0,1,""],to_iso8601:[38,0,1,""],to_timestamp:[46,0,1,""],to_unixtime:[38,0,1,""],to_utf8:[45,0,1,""],trim:[45,0,1,""],truncate:[43,0,1,""],try_cast:[37,0,1,""],upper:[45,0,1,""],url_decode:[47,0,1,""],url_encode:[47,0,1,""],url_extract_fragment:[47,0,1,""],url_extract_host:[47,0,1,""],url_extract_parameter:[47,0,1,""],url_extract_path:[47,0,1,""],url_extract_port:[47,0,1,""],url_extract_protocol:[47,0,1,""],url_extract_query:[47,0,1,""],var_pop:[30,0,1,""],var_samp:[30,0,1,""],variance:[30,0,1,""],week:[38,0,1,""],week_of_year:[38,0,1,""],width_bucket:[43,0,1,""],year:[38,0,1,""],year_of_week:[38,0,1,""],yow:[38,0,1,""],zip:[31,0,1,""]},runtime:{kill_query:[19,0,1,""]}},objnames:{"0":["py","function","Python function"]},objtypes:{"0":"py:function"},terms:{"00u":196,"0b8e":11,"0prrybcp1ygj8xcbpmwhl5":13,"0th":38,"0x00ff00":34,"0xff0000":34,"0xffff00":34,"10ffff":71,"11kb":196,"14m":44,"160b":196,"16be":46,"1b8af1a7451a":11,"1gb":[2,53],"1st":38,"20151207_215727_00146_tx3nr":19,"25m":154,"28t17":13,"2nd":38,"32m":53,"3ca":44,"3cb":44,"3rd":38,"45kb":196,"49mb":196,"4mb":15,"50gb":53,"55b151633864d6438c61a9c":15,"5gb":53,"64bit":28,"64kb":12,"6lreav6kr6plvcgl2arl":13,"7day_act":60,"8byte":28,"8mb":172,"9th":144,"__hive_default_partition__":[156,158],"_col0":[13,139,202],"_col1":[139,195],"_col2":202,"_col3":202,"_host":10,"_id":15,"_kei":[12,13,18],"_key_corrupt":[12,13,18],"_key_length":[12,13,18],"_messag":[12,13],"_message_corrupt":[12,13],"_message_length":[12,13],"_orc_":51,"_partition_id":[12,13],"_partition_offset":[12,13],"_schema":15,"_segment_count":[12,13],"_segment_end":[12,13],"_segment_start":[12,13],"_valu":18,"_value_corrupt":18,"_value_length":18,"abstract":[6,60,65,134],"boolean":[10,12,13,15,18,25,30,31,34,36,40,41,43,44,55],"break":[123,144],"byte":[6,12,13,18,19,25,32,47,93,94,106,118,144,146,153,164],"case":[7,9,10,12,15,24,25,30],"catch":[1,2,138],"class":[6,8,9,24,25,26,44,53,54,98,114,119,123,127,134,138,147,156],"default":[2,3,6,7,8,9,10,11],"export":[2,53],"final":[13,16,17,25,55,67,127,144,147,195,196,202],"float":12,"function":[12,13,21,23,24],"import":[22,138,144],"int":[8,12,34,55,56,101],"long":[10,12,13,19,22,25,28,68,108,138,140,154],"new":[1,2,6,7,9,12,15,18,19,24,25,26,28,36,55,65,66,67,73,77,80,83,87,90,92],"null":[6,7,8,9,13,18,25,30,31],"public":[24,25,138,197,200],"return":[7,12,15,22,23,24,25,27,28,30,31,32,33,34,35,36,37,38,40,42,43,44,45,46,47,48,60,66,77,83,86,87,89,93,100,101,104,105,114,119,120,123,127,128,132,138,144,152,154,156,167,180,202,215],"short":[6,12,34],"static":[2,25],"switch":155,"throw":[12,93,168],"true":[2,6,8,9,10,12,13,18,25,30,31,34,35,36,41,44,51,53,58,62,65,88,93,101,102,103,108,134,148,153,158,161,168,179,180,195,196,203],"try":3,"typeof":[37,127],"var":[53,147],"void":[25,138],"while":[6,9,53,56,79,88,138,168,174,202],aaa:36,abandon:[144,147],abbrevi:38,abil:[6,11,65,90,97],abl:[9,12,144,179,180],abort:[83,116,127],abortedexcept:155,about:[4,6,8,9],abov:[2,7,12,16,17,18,25,35,38,51,53,71,87,144,147,180,196],absent:12,absolut:[2,9,43],accept:[1,2,4,12,25,34,53,79,88,166],access:[4,5,8],accessor:155,accomplish:9,accor:13,accord:[2,12,13,34,43,48],accordingli:11,accou:13,account:[10,13,70,72,91,93,96,98,111,116,129,133,144,151,202],account_bal:13,accountbal:13,acctbal:202,accumul:25,accumulatorst:25,accumulatorstatefactori:25,accumulatorstatemetadata:25,accumulatorstateseri:25,accumulo:5,accumulo_hom:6,accumulorowseri:6,accumulot:6,accur:[93,196],accuraci:[30,90,93,96],achiev:180,acknowledg:[8,15],acl:10,aco:43,acquir:1,across:[27,48,53,133,138,153],act:52,activ:[3,23,82,127,140],actual:[10,13,24,36,53,106,108,133,154],adapt:[22,179,180],add:[6,8,9,10,12],addit:[6,8,9],addition:[1,2,4,6,43,44,45,64,66,67,87,138,147,151,153,154,156,179,197,200,202],addprinc:[179,180],address:[8,13,179],adher:60,adhoc:2,adhoc_:2,adjust:[8,15,103,116],admin:[1,2,10,179,180],admin_serv:[179,180],advanc:[8,136,144,148],advantag:[76,146],affect:[9,157],africa:202,after:[1,6,9,10,23,27,43,48,53,55,60,73,79,80,83,96,120,128,144,154,158,169,179,180,202],again:6,against:[2,6,8,10,12,13,22,55,56,148,153,158,168],agent:127,agg:122,aggreg:15,aggregationfunct:[25,123],ainst:13,air:190,airlift:13,akiaiosfodnn7exampl:135,alan:6,algeria:202,algorithm:[20,30,133,152],alia:[20,30,38,43,46,79,127,168,180,191,202],alias:[118,215],alic:[197,200],align:[92,133],all:[1,2,3,4,6,8,9,10,11,12],alloc:[12,67,77,155,160,162,164,171,172,176],allow:[1,2,3,7,8,9,10,12,13,14,15,16,17,18,22,24,26,27,28,53,66,68,72,77,83,88,90,101,117,119,122,123,127,132,135,138,139,147,148,153,154,155,156,158,166,168,187,197,202],allview:123,alon:13,along:[4,8,19,80,114,119,196,205],alphabet:32,alphanumer:[47,153],alreadi:[6,9,108,153,179,180,186,187,188,189],also:[1,2,3,6,7,8,9,11,13,20,23,24,25,27,28,35,40,42,53,62,65,67,88,89,90,93,103,113,119,132,133,134,144,147,151,179,180],alter:[6,10,16,17,27,49,83,88,127,153,171,181],altern:[25,53,62,139,148],although:[12,15,102,133,154,158],alwai:[7,12,18,44,45,60,65,73,76,77,80,93,119,129,138,154,196],amazonaw:132,amazons3cli:9,ambigu:[121,202],america:[38,58,119,144,202],among:[2,13],amount:[2,24,53,62,67,77,88,180],analog:48,analysi:[23,55,62,65,96,134,161,202],analyt:62,analyz:[4,19,49,96,108,138,152,181,195],ancestor:2,anchor:44,angel:144,angl:43,ani:[1,2,6,7,8,9,12,13,15,20,25,27,30],anim:[139,202],annot:[25,26,123],announc:77,anonym:215,anoth:[8,9,12,15,16,17,18],another_orderd:187,another_orderkei:187,ansi:34,answer:[8,135],anymor:138,anyth:53,anywher:[139,215],apac:87,apach:[6,8,9,12],api:[6,9,13,22,55,65,77,83,98,101,114,119,120,129,133,136,139,153],app:24,appear:[12,83,93,96,138,144,180,202],appendnul:25,appl:[139,184],appli:[2,9,60,72,90,107,114,119,127,153,164,179,202],applic:54,applicationnam:[1,2],appropri:[6,9,12,15,16,17,18],approx_avg:153,approx_distinct:[30,101,135,140,166,168],approx_percentil:[30,88,90,101],arbitrari:[8,12,18,30,77,83,122,153,166,202],arc:43,archiv:[179,180],argentina:202,argument:[9,10,25,31,34,35,36,38,39,43],argumenttyp:25,arithmet:[30,33],ariti:155,around:25,arrai:[6,9,12,15,29,30],array1:31,array2:31,array_agg:[30,65,96,119,120,122],array_distinct:[31,64,68,104,127],array_el:79,array_intersect:[31,65,118],array_join:[31,66],array_max:[31,73],array_min:[31,73],array_posit:[31,65],array_remov:[31,67],array_sort:[31,119,127,158],array_union:[31,123],arriv:[12,13],artifact:138,artifactid:26,asc:202,ascend:[30,43],ascii:[47,154,175],asia:[70,202],asin:43,ask:[9,24,35,55],assembl:26,assert:66,assign:[9,153,161,179,180],associ:[2,6,9,10,30,65],assum:[9,12,13,25,38,39,43,45,66,168],async:13,asynchron:[130,154],atan2:43,atan:43,atom:127,attempt:[6,9,22,68,127,128,131,133,168],attribut:[12,13,164,196,205],auspic:62,auth:6,authent:8,author:[6,9],auto:[6,65,119,144],auto_incr:56,autocommit:4,autocomplet:67,automat:[9,19,25,37,53,67,83,93,147,153],automobil:[13,202],avail:[1,3,4,5,6,8,9,11,12,13,14,15,16,17,18,19,24,26,52,53,55,64,83,87,119,133,144,147,156,179,180,184,186,187,188,204,208],averag:[25,30],averageaggreg:25,avg:[30,127,153,202],avg_doubl:25,avoid:[8,53],avro:129,awai:[6,132],await:[4,138],awar:[8,44,87],awscredentialsprovid:9,azeri:45,b09:11,back:[6,13,22,26,81,119,133,148,152,168],background:[8,77],backoff:[8,9,65,154],backquot:60,backslash:44,backup:161,backward:[65,69,77,82,83,98,104,122,123,127,130,133,134,138,144,145,153,156,167,168,176],bad:[6,15],balanc:[119,153,202],banana:139,banned_us:10,bar:[6,34,58],base64:[32,153],base:[6,8,9],bash:179,basi:[3,9,102,144,158],basic:9,batch:[6,8],batchscann:6,batchsiz:15,batchwrit:6,bb14:11,bbb:36,bean:[11,13],bear:139,becaus:[6,10,13,26,53,55,144,147,155,202],becom:[2,15,68,88],been:[4,9,10,23,27,51,62,65,66,73,80,83,102,103,144,147,148,153,154,155,158,167],befor:[1,2,6,7,9,12,27,48,65,69,76,80,93,96,98,104,108,114,118,119,122,123,127,129,130,133,134,138,145,147,153,167,168,173,176],begin:[6,48,62],behav:7,behavior:[6,9,12,27,52,60,66,99,116,122,138,148,187,202],belong:2,below:[1,2,6,10,12,18,25,28,34,39,53,58,144,180,196],ben:30,benchmark:[20,49,50],benefit:158,berlin:144,berner:6,bernoulli:202,besid:13,best:[6,53,58,134],beta:[12,153],better:[25,123,168],between:[6,12,16,17,18,24,25,30,34],big:22,bigger_ord:187,biggest:35,bigint:[6,7,8,9,12,13,15,18,30,31,32,33,34,35,36,37,38,40,42,43,45,46,47,48,55],biginttyp:[25,28],billion:116,bin:[13,43,53,179],binari:[28,29,30],bind:[25,132,202],bird:202,birthdai:6,bit:[6,11,25,33,58,88,167],bit_count:[33,101],bitwis:[29,30],bitwise_and:[33,101],bitwise_and_agg:[30,131],bitwise_not:[33,101],bitwise_or:[33,101],bitwise_or_agg:[30,131],bitwise_xor:[33,101],black:5,blackhol:[7,90],blith:13,blithel:13,blk:44,blob:[83,148],block:[4,9,15,28,44,64,65,68,69,70,82,107,129,136,138,153,176,180,202],blockbuild:25,bloom:127,bloomberg:6,blue:34,bob:[1,2,42],bob_ag:42,bodi:92,bogu:104,bold:13,boldli:13,book:[40,153],bool:55,bool_and:[30,168],bool_or:[30,168],boost:13,bootstrap:[24,127],both:[2,3,6,8,9,11,12,25,35,41,42,53,62,72,80,87,133,138,144,147,148,153,155,197,200,202],bottleneck:4,bougainvil:70,bound1:43,bound2:43,bound:[30,43],boundari:44,bpxrficyexamplekei:135,bracket:153,broadcast:[3,155],broken:[18,77,84,121,127,144,154],broker:13,bucket:[9,30,43,48,87,108,109,116,118,121,128,131],bucket_count:9,bucketed_bi:[9,118],buffer:4,bug:[73,74,79,81,86,90,99,102,103,106,107,109,111,116,119,121,136,137],build:[13,25],builder:25,built:[6,13,25,26,28,58],bundl:[6,90,136],burncaniff:13,busi:12,button:[4,127],byqueri:154,bytecod:148,byteorderedpartition:8,cach:[6,8,9,65,77,90,106,127,128,132,147,148,154],cafe510:13,cajol:13,calcul:[34,39,48,142,144,202],calendar:58,california:[36,202],call:[9,13,19,22,24,25,26,49,53,60,62,69,72,97,111,116,121,139,144,147,181],callabl:184,callback:65,caller:77,can:[1,2,3,4,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,22,23,24,25,26,27,28,30,31,34,35,36,37,38,44,45,47,48,51,52,53,54,55,56,58,60,62,66,67,68,69,72,73,75,77,80,82,87,88,89,90,92,93,94,96,97,100,102,103,104,107,108,111,116,118,119,122,123,127,130,132,133,134,135,137,138,139,142,144,147,148,152,153,154,155,156,157,158,166,168,179,180,184,186,187,188,189,195,196,202,204,206,210,212,215],cancel:[71,72,83,93,120,147],canhandl:144,cannot:[6,18,28,71,148,153,179,180],canon:[45,65,168],capabl:[6,20],captur:[34,44,51,53,58],cardin:[6,31,42,60,156,158,202],care:[9,144],caref:13,carefulli:[13,52],cartesian:202,cashforevercd:13,cassandra:5,cast:[13,36,37,41,58],cat:[37,202],catalog:[6,7,8,9,10,11,12,13,14,15,16,17,18],categor:[104,123,145,147],categori:44,caus:[1,2,3,4,9,51,67,69,70,71,73,76,77,79,82,85,86,87,88,93,96,97,103,104,107,109,111,116,118,121,123,124,128,131,142,144,146,155,156,157,158,160,162,166,171,172,173,174,186,187,188,189,192,193,194],caution:[12,155],cbrt:43,ccc:36,cdh4:[9,132],cdh5:9,cdh:[9,172],ceil:[43,127],cell:[6,18],central:13,certain:[36,68,76,89,90,104,127,128,135,138,145,148,153,154,168,202],certif:180,chain:[119,202],challeng:180,chang:[6,9,53],chapter:[5,181],char2hexint:[46,72],char_octet_length:123,charact:[18,34,37,38,44,45,46,47,53,58,66,83,96,153],chart:34,check:[10,27,45,66,82,96,101,108,119,171],checkpoint:176,checksum:[30,80,82,130],china:93,chita:70,chmod:[13,51,52,56],choos:[74,146,153,180],chose:153,chosen:11,chr:[45,154],chunk:[22,24],cipher:180,citi:[135,180,198],classif:[71,141,142],classifi:[62,138,147],classpath:[6,9,26],claus:[6,9,36,48,60,69,72,76,87,89,92,106,118,122,133,138,139,144,148,152,164,168,175,186,187,188,189,190,192,193,194,197,200],clean:[120,168],cleaner:9,cleanup:118,clear:[77,93,169],clerk:[48,196],cli:[1,2,6,10,13,27,49],click:[4,16,17,53,55],client:[1,2,4,8,9],clientconfigur:9,clock:[102,144,158],close:[8,15,69,138,155],closeabl:145,cloudera:9,clue:180,cluster:[2,3,6],clustered_bi:118,coalesc:30,code:6,codebas:25,codec:[9,106,132],coeffici:30,coerc:[12,148],coercion:[66,69,75,82,83,102,108,111,116,144,175],col_famili:6,col_nam:6,col_qualifi:6,collat:13,collector:119,colloc:9,coloc:[118,119],colon:[6,12,153],color:29,colorado:202,column_alia:202,column_express:215,column_filter_optimizations_en:6,column_map:6,column_nam:[183,187],column_s:123,columnar:[94,111,118,120,147],columnar_dictionari:120,columnar_process:120,columnar_processing_dictionari:[94,96,97,120],columnarserd:144,columnhandl:[65,144],columnmetadata:[69,104],com:[3,6,10,11,13,26,53,132,179,180],combin:[9,25,28,35,45,66,104,127,133,154,202],combine_hash:196,combinefunct:25,come:[1,2,30,42,80,144],comma:[6,8,9,11,12,15,18,24],command:[6,10,18,49,50,51],comment:[6,8,12,13,51,98,104,148,152,198],commit:[4,49,88,119,129,168,181],common:[4,10,20,25,35,77,133,144,180],commun:[9,53,62,97,133,154],compact:[76,104],compar:[28,35,64,83,85,90,133,161,164,166,174,177],comparis:85,comparison:29,compat:[9,25,38,45,46,72,123,127],compil:[111,116,129,138,144,148],complement:[28,30,33,41,58],complet:[4,10,23,52,65,72,82,90,92,108,119,127,133,139,158,168,179,180,196],complex:[6,20,25],complianc:83,compon:[7,9,34,47,48,58,114,119],compos:[10,202],composit:45,compress:[9,51,53,106,107,132,144,172],comput:[6,9,25,30,32,48,111,116,129,130,141,144,202],computation:4,concat:[31,45,77,96,97],concept:[22,27,60,147],concern:6,concret:25,concurr:[64,67,73],condit:29,conf:[9,10,179,180],config:[1,2],configur:0,confirm:180,conform:[47,168],congest:116,conjunct:[36,115,202],connect:[1,2,6,8,9,10],connecticut:202,connectoraccesscontrol:[27,82,127],connectorcolumnhandl:[65,144],connectorcontext:127,connectorfactorycontext:127,connectorhandleresolv:[22,153],connectorid:24,connectorindex:176,connectoroutputhandleresolv:153,connectorpagesink:[130,168],connectorpagesourc:[155,157],connectorpartit:[65,144],connectorpartitionresult:144,connectorrecordsinkprovid:153,connectorsess:[77,144,156],connectorsplit:144,connectorsplitmanag:22,connectorsplitsourc:[122,144,145],connectortablehandl:144,connectortablelayout:104,connectortablemetadata:123,connectortyp:144,consecut:123,consid:[6,10,35,53,131,148,153,202],consist:[8,12,15,18,53,80,97,154],consol:180,consolid:153,constant:[7,30,35,43,60,75,77,80,83,88,90,96,104,111,116,119,153,164,168,202],constraint:[133,195],construct:[36,60,119,144],constructor:[9,122],consum:[2,4,7,8,10,12,13,28],contact:8,contain:[4,6,10,11,12,13,14,15,18,19,24,25,26,28,30,31,34,40,42,44,45,47,48,51,53,65,66,71,72,90,93,101,104,117,120,123,127,129,130,131,133,144,147,148,153,156,158,164,168,171,172,174,177,180,186,188,189,202],content:[7,8,9,11,12,14,15,16,17,18,20,26,53,65,102,132,138,177,180],context:[44,45],continu:[6,10,51,56,62,138,180],contrast:60,contributor:21,control:[1,6,7,12,15,18,21,26],control_catalog:56,control_password:[56,171],control_postqueri:[56,88],control_prequeri:[56,88],control_queri:56,control_schema:56,control_usernam:[56,171],conveni:[6,24],convers:[6,9,12,29],coordin:[4,7,10,23,26,27,49,53,55,65,68,70,88,90,96,110,116,119,127,129,131,132,133,138,140,141,144],copi:[9,127,154,179,187],core:[9,10,24,119,153],corr:[30,68],correct:[9,10,15,37,45,66,83,88,96,101,108,113,119,127,130,132,133,148,152,168,180],correctli:[6,65,69,113,118,119,133,140,144,152,153,166],correl:[30,96,106,127,130,196,202],correspond:[6,8,18,20,24,25,42,127],corrupt:[13,36,107,176],cosh:43,cosin:43,cosine_similar:[43,115,122],cost:[144,196],could:[6,10,12,18,73,79,81,87,88,90,93,97,100,101,104,107,114,119,121,123,124,128,131,133,138,146,147,148,154,155,164,165,166,167,174],count:[7,8,11,12,13,15],count_8:[195,196],count_if:30,counter:140,countri:[9,133,135,180],court:13,covar_pop:[30,68],covar_samp:[30,68],covari:30,cow:202,cpu:[2,3,51,67,68,70,90,96,99,107,119,121,129,131],cpuquotaperiod:2,cql:[8,151],cqlsh:8,crash:[88,90],creat:[6,7,8,9,10,11,12],created_at:13,creation:[7,23,67,90,98,123],creativ:22,criteria:[69,83,106,127,129,134],critic:[53,147],cross:[60,86,87],cryptograph:[179,180],css:34,ctrl:[72,83,93],cube:[43,106,202],cumbersom:12,cume_dist:48,cumul:[48,98],curl:13,current:[2,4,6,9,10,11,12,19,30,38,46,48,55,67,72,77,80,82,87,88,90,93,133,134,147,148,153,157,185,186,201,202,210,211,212,213,214],current_d:[15,38,101],current_tim:38,current_timestamp:38,current_timezon:[38,160],custkei:[74,153],custom:[6,8],custom_scientist:6,customer_kei:13,customerkei:13,cyan:34,da_juanand_onli:13,daemon:[53,154],daemontool:53,dai:[31,38,46,48],data:[3,4,5],data_1_week:133,data_1_year:133,data_typ:[183,187],databas:[9,15,16],databasemetadata:[65,83,87,123,138],datacent:8,dataformat:[12,13,18],datanod:9,dataset:138,datasourc:138,datasourcenam:122,datatyp:6,date:[6,9],date_add:[38,65,144],date_diff:[38,65],date_format:[38,64,78,127,144],date_pars:[38,64,78,120,121,127,144],date_trunc:[38,144],datetim:[46,55],datetimeformat:38,day_of_month:38,day_of_week:38,day_of_year:38,daylight:144,dcawareroundrobinpolici:8,ddc4df17:11,ddl:6,deadlock:[66,67,68,97,118,127,175],debug:[11,23,53,83,172],dec:38,decemb:38,decim:[28,29],decimal_digit:123,decis:[20,30],declar:[25,51,77,96,133],decomposit:45,decompress:[171,175],decrypt:9,dedic:53,default_valu:48,defaulteventhandl:13,defin:[1,2,6,10,11,12,13,15,18,23,25,26,27,28,34,38,39,97,148,184,202,215],definit:6,degre:[43,64],delai:[7,80],deleg:24,delet:[6,9,10,15,16,17,49,66,71,87,90,107,119,127,181],deleted_table_nam:15,delimit:6,deliv:22,demonstr:[35,41,53,202],deni:27,denot:[197,200],dense_rank:48,deploi:13,deploy:[10,12,18,53],deposit:13,deprec:[64,65,86,122,127,131,147],depth:[10,25],desc:[48,202,209],descend:30,describ:[2,5,6,8,12,13,15,16,17,18,38,46,49,53,58,65,66,127,128,131,132,144,148,152,181],descript:[6,8,9,10],descriptor:[11,117,123],deseri:[6,92,104],design:[7,61,62,127],desir:[7,27,180],destination_st:202,destination_zip:202,detail:[4,6,9,10,15,28,55,58,72,82,86,93,101,107,123,124,127,135,136,148,158,175,180,184,190,197,200],detect:[13,15,69,97,119,133,138,144,154,175],detector:[87,132],determin:[20,27,40,43,44,48,60,202],determinist:[20,104,171,202],dev:[7,13],develop:13,deviat:[30,51],devic:7,devot:24,dhadoop_user_nam:9,diagnos:3,diagnost:53,dictionari:[94,95,97,120,125,127,129],dictionary_aggreg:97,dictionaryblock:98,did:101,differ:[5,6,7,8,9,10,12,13,15,16,17,18,25,26,44,48,51,52],difficult:[6,12],digit:[38,39,43,46,58,120],direct:[80,113,119,202],directli:[6,9,13,20,25,44,122,123,132,144,179,184],directori:[6,9,10,12,14,18,24,26,51,53,65,117,120,127,136],disabl:[10,51,52,65,73,77,86,87,91,96,119,120,121,148,154,158,168,171,174],disallow:147,disappear:12,discard:[7,108],discov:[8,15,127],discoveri:[8,53,65,132,137],discuss:[9,10,184],disk:[4,10,133,138,202],displai:[68,83,86,93,99,123,140,148],disrupt:91,distinct:[13,30],distinguish:133,distribut:[2,3,8,9,10,22,24,30,48,53,61,62,67,77,80,83,103,116],distributed_join:[3,75,174],divid:[2,43,48],divis:[36,43,60,139],djava:10,dlog:180,dness:13,document:[4,6,8,9,10,15,22],doe:[2,6,9,10,13,22,24,25,30,35,48,53,55,88,101,107,117,131,132,133,135,138,147,154,179,180,186,187,188,192,193,194,202],doesn:[1,19,22,35,40,106],dog:202,doi:38,dollar:44,domain:76,domain_realm:[179,180],don:[6,22,25,164,168],done:[6,55,92],donotinitializelog:24,dot:[53,138,156],doubl:[9,11,12,13,15,25,30,34,35,37,38,43,55],dow:38,down:[6,7,18,43,65,68,90,102,117,119,127,138,143,158],downgrading_consist:8,download:[13,51,52,53,54,56,179,180],dramat:148,drastic:6,drawn:34,driver:[8,15,49,50],drop:[6,8,9,10,12,15,43,49,65,77,115,117,118,127,147,148,151,181,186,187,189],dsun:[179,180],due:[12,13,66,67,68,88,90,107,121,127,134,137,138,144,168],dummi:[7,12],dump:[11,53,158],duplic:[31,72,104,119,148,202],durat:[6,80,154],dure:[7,28,53,64,68,83,90,96,117,128,129,131,133,138,148,161,167,202],dwrf:[103,120,129,155],each:[3,4,6,7,10,11,12,13,14,15,18,19,22,24,25,26,30,36,45,48,51,53,56,66,67,77,114,119,128,133,135,138,153,156,164,171,179,196,198,202],each_quorum:8,earli:[71,127,138],earlier:[13,169],eas:[138,172],easi:138,easier:[81,133,153],easiest:6,easili:[53,127],east:202,eat:13,ec2:[9,65,83,93],effect:[6,30],effici:[62,70,96,102,119],eiger:180,eight:[12,13],either:[6,9,12,15,16,17,25,31,34,35,41,45,60,96,133,202],elad:30,element:[15,30,31,40,45,60,66,79,86,96,127,133,153,155,168],element_at:[31,42,77,119],elig:2,elimin:202,els:[12,25,36,97],embed:[53,132],emploi:22,empti:[7,44,45,52,72,93,113,117,119,120,148,153,168,186,187,188,192],empty_n:188,emr:9,enabl:[2,3,6,9],encod:[6,12,28,32,40,45,46],encount:[36,90],encourag:138,encryptionmaterialsprovid:[9,93],end:[6,8,9],endpoint:[9,121,127],enero:144,enforc:[2,10,117],engin:[22,25,61,116,135,138,144,153,156],english:38,enough:[4,8],ensur:[10,15,24,179,180],enter:[87,180],entir:[9,12,22,44,67,87,114,119,196],entri:[11,15,26,77,128,179,180],entrydelimit:45,environ:[9,27,52,53,104],environment:53,epitaph:13,epoch:[12,13,28],equal:[7,12,25,31,35,36,39,106,127,133,202],equat:90,equi:[43,69,92,115,119,122],equijoin:152,equival:[30,35,36,37,60,202],error:[6,9,10,12,13,30,35,36,48,53,65,66,71,82,85,88,90,92,95,96,104,105,106,107,117,118,120,123,124,127,128,129,131,132,138,139,141,142,144,145,147,148,152,153,154,162,164,166,168,180,186,187,188,189,192,193,194,202],errorcod:65,errornam:65,errortyp:65,escap:[44,47],especi:196,essenti:[6,25],establish:[8,15],estim:106,etc:[2,4,6,7,8,9,10,11,12,13,14,15,16,17,18,20,23,27,53,55,75,88,89,90,92,104,123,127,132,133,138,139,147,148,152,179,180],euler:43,europ:[144,202],evalu:[35,36,40,41,44,48,60,96,104,120,127,134,202],evaluate_classifier_predict:147,even:[12,13,22,35,144,202,215],evenli:[48,138],event:[8,21],eventlisten:23,eventlistenerfactori:[23,26],eventu:[67,172],everi:[6,9,10,11,16,17,20,30,44,53,64,89,127,135,144,153,168,202],everyon:[197,200],everyth:[12,45,83],everytim:189,exact:67,exactli:[39,127,198,202],exampl:[1,2,6],exampleaveragefunct:25,examplecli:24,exampleconnectorfactori:24,examplefunctionsplugin:25,examplemodul:24,examplenullfunct:25,exampleplugin:26,examplerecordcursor:24,examplestringfunct:25,exce:[76,128,164],except:[2,9,24,30,39,44,48,60,71,72,82,87,88,93,104,118,123,135,138,154,156,158,180],excess:[65,67,68,160,162,166,171,172],exchang:[110,116,120,121,138,195],exchangecli:90,exclud:[129,187],exclus:[12,43],excus:13,execut:[1,3,4,9,10,11,19,22,27,28,51,52,53,56,65,67,68,72,73,83,87,91,93,96,106,118,121,127,135,147,153,156,158],executor:138,exhaust:15,exist:[6,9,12,15,18,20,30,36,40,65,75,77,90,92,106,108,118,122,131,132,138,144,147,154,155,179,180,182,183,186,187,188,189,192,193,194],existing_table_nam:187,exit:[83,92,96],exp:43,expand:[1,2],expect:[6,22,28,37,44,62,67,77,82,83,88,93,133,138,144,153],expens:[4,6,171,172],experi:147,experiment:[2,67,73,77,80,82,103,118,129,144,147,155,157,158,161],experimental_big_queri:[73,158],expir:[6,97,120,128,161,164],explain:[10,39,49,66,72,108,147,153,168,181],explan:[10,53],explicit:[13,45,66,138,144],explicitgcinvokesconcurr:53,explicitli:[10,37,106,202],explit:202,explod:[60,157],exponenti:[9,152,156],expos:[75,98,106,118,119,139,143],expr:37,express:[13,29,35],ext:6,extend:[6,25,62,65,66,77,134,145,156],extens:[11,35,51,102,144,148,154,158],external_loc:[9,131],external_t:6,external_table_idx:6,external_table_idx_metr:6,extract:13,extrem:147,face:3,facebook:[3,6,11,26,53,62],facil:9,fact:62,factor:[20,60],factori:[8,22,24,127],fail:[2,4,8,12,13,36,37,53,65,72,77,80,86,87,88,92,96,97,100,104,108,111,115,116,118,121,123,124,127,128,131,132,133,138,144,148,152,154,155,161,162,166,167,168,170,180,202],failov:8,failur:[9,10,23,36,66,79,83,85,87,88,90,111,116,119,120,121,122,123,127,129,130,132,138,139,142,152,168],failure_host:104,failure_task:104,fair:2,fall:[34,35,148,168],fallback:[9,133],fallthrough:8,fals:[2,6,8,9,10,12,13,15,18,25,30,34,35,41,51,53,58,65,72,73,88,106,107,121,127,147,148,152,158,162],false_valu:36,fama:6,famb:6,famc:6,famd:6,fame:6,famf:6,famili:6,familiar:[13,148],fanci:15,far:6,fast:[4,66,133],faster:[66,135,144,153],favor:[73,171,172],favorit:13,favorite_count:13,feder:9,fetch:[8,13,15,40,120,127,133,168],few:[4,9,10,20,26,44,53,67,133,144],fffd:45,ffff:53,ffffffff:53,ffffffffffff:53,field_length:[7,90],file:[1,2,5,6,7,8],file_format:51,filenam:[1,147],filesystem:[9,53,127,139,152],fill:[31,55,198],filmarsivimiz:13,filter:[6,18,51,60,76,94,112,118,119,120,127,130],financ:214,find:[8,18,19,23,27,36,44,53,127],finish:[1,4,70,71,79,130,138,173],finit:43,firewal:15,first:[1,2,6,9,10,11,24,25,31,36,38,44,45,47,48,53,55,60,113,119,123,136,138,147,152,153,180,202],first_el:[31,60],first_valu:[48,68,77,148],fit:[3,15,34,155],five:[1,2,153,202],fix:[12,15,38,58,64,65,66,67,68,69,70,71,72,73,74,76,77,78,79,81,82,83,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,116,117,118],fixedsplitsourc:122,flag:[2,15,44,67,77,80,98,116,120,122,131,152,155],flat:3,flatten:[31,118,202],floor:[43,127],fly:20,fname:8,focu:[13,153,180],folder:[12,13,18],follow:[1,2,3,4,6,7,8,9,10,11,12,13,14,15,16,17,18,20,22,23,24,25,26,34,35,36,38,41,44,45,46,47,48,51,53,54,55,56,60,72,73,87,127,132,138,144,147,153,156,158,180,186,187,188,202],foo:[6,9,58,60],forc:[9,120,128,148,157],force_local_schedul:[10,157],forcibl:53,foreground:53,forev:[73,107],form:[13,28,35,36,45,55,86,90,138,148,202],format:[6,9,12,13,18,24,34,38,46,51,53,54,87,103,106,107,114,118,119,129,130,133,134,144,147],format_datetim:38,formathint:12,formatt:13,forth:6,forward:144,found:[6,8,10,24,26,30,31,36,42,45,66,67,138],four:[12,38,53],fox:13,fraction:[34,38,39,58],fragment:[47,168,171,172,195,196],frame:[48,113,119,128,166],framework:[6,9,25,153,155],francisco:198,free:[70,169],frequent:[6,28,103],fresh:71,from:[1,2,4,5],from_bas:[43,64],from_base64:32,from_base64url:32,from_hex:[32,68],from_iso8601_d:[38,72],from_iso8601_timestamp:[38,72],from_item:202,from_unixtim:[38,130],from_utf8:[45,66],fruit:139,fsync:15,fsync_saf:15,full:[4,6,25,60,65,66,76,83,89,96,132,133,144,174,202],full_nam:13,fulli:[6,9,53,83,135,144,154,158,184],functionfactori:123,fundament:127,fur:13,furiou:13,furnitur:[13,202],further:[13,18,55,119,133,153,202],futur:[64,65,67,80,81,122,127,131,144,152,153,154,156,189],g1heapregions:53,gap:48,garbag:[51,119,148,154,166],gatewai:56,gather:195,gener:[6,10,13,20,25,28],general_categori:44,genkeypair:180,geometr:30,geometric_mean:[30,83],get:[4,6,8,12,22,51,60,80,83,154,180],getallview:123,getcatalog:138,getcollect:15,getcolumn:[87,123],getcolumntyp:168,getconnectorfactori:[22,24,26,123],getdatasourcenam:122,getdefault:6,getdiscretepred:104,getdoubl:25,getfunct:[25,123],getidentifierquotestr:65,getinst:24,getjavatyp:28,getlargeupdatecount:93,getlong:25,getnam:[23,24,27],getparametrictyp:28,getproperti:[77,156],getresourcegroupconfigurationmanagerfactori:127,getschema:138,getservic:[123,138],getsystemt:64,gettabl:138,getter:25,gettyp:[28,123],getupdatecount:93,getvers:127,github:6,give:10,given:[4,6,9,12,15,22,24,25,27,30,31,42,48,58,119,202],glob:14,global:1,goal:24,goe:[4,132,180],gone:153,gonna:6,good:[12,15,22,26,53],govern:[9,10],grace:6,grammar:[133,156],grant:[9,10,16,17,49,127,181],grant_select:10,grante:[197,200],granular:[18,202],graphem:[45,66],graphic:4,graphviz:195,greater:[30,35,43,48,100,114,119,126,127,202],green:34,ground:133,groundwork:152,group1:6,group2:6,group:0,groupedaccumulatorst:25,groupid:26,grouping_el:202,gu8tn:13,guarante:[30,35,67,127,202],guava:[24,25],guess:15,guest:10,guic:24,guid:[8,10],gzip:[9,106,107,144],had:[6,73,76,114,119,127,147],hadoop1:[9,132],hadoop2:[9,135],hadoop_user_nam:9,haggl:13,haim:30,half:189,hand:[6,164],handl:[6,23,24,26,35,36,41,44,47,62,65,67,68,72,76,77,83,90,92,93,104,106,113,114,118,119,123,127,128,136,138,139,141,142,146,148,153,155,159,161,162,176],hang:[68,73,93,132,137,144,154,155,156],happen:[24,25,27,76,103],hardcpulimit:2,hash:[3,8,18,32,65,67,73,75,80,86,87,119,130],hash_cod:196,hash_partition_count:65,hashaggreg:155,hashvalu:196,have:[1,2,3,6,7,8,9,10,11,12,13,15,16,17,18,22,24,25,27,31,35,48,51,53,65,66,69,77,80,83,86,87,92,98,102,103,104,108,122,123,124,127,129,130,133,134,135,138,139,144,145,147,148,152,153,154,158,165,167,168,176,179,180,184,190,196,197,200],hbase:133,hdfs_user:9,header:[97,130,144],heap:[3,53,119,120,171,172],heapdumponoutofmemoryerror:53,heartbeat:174,heavi:6,heavili:[8,11,102,131,154,158],hello:35,help:[3,6,8,51,52,53,127,172,179,180],here:[6,12,18,22,35,53,179,180,184],heterogen:61,heurist:73,hex:[32,116,153,158],hexadecim:[46,47],hh24:46,hidden:[12,13,15,18,65,93,138,148,171],hierarch:79,hierarchi:53,high:[6,7,9,28,34,71,83,144,180],high_color:34,higher:[129,144],highest:[12,202],highli:[9,12,15,20,116,144,161,164],hint:12,hiragana:44,histogram:[30,43,75,87,158],histori:[11,65,67,110,116,119,127],hit:90,hive:5,hiveql:[9,60],hivesessionproperti:77,hivesplitsourc:137,hold:[6,12,18,25,28,53,186],hole:5,home:179,honor:119,hopper:6,horizont:34,host1:[8,12,15],host2:[8,12],host:[3,8,9,10],hostnam:[10,12,15,18,55,180],hotspot:11,hour:[38,46,58,78,144,148,152],household:[13,202],how:[2,6,9,12,13,19,22,48,67,77,103,132,138,202],howev:[6,7,9,12,28,44,67,202],html:[55,108],http:[4,6,9,13,14,21,22],hundr:[171,172],hyperbol:43,hyperloglog:93,i0b10bb0aymmc:13,iam:9,iana:[38,179,180],icon:86,id_str:13,idea:13,ideal:12,ident:[6,10,19,20,28,128,202],identifi:[26,47,53],idl:[15,19,67,97,116],ieee:[12,58],ignor:[3,7,10,12,20,30,46,66,72,93,106,120,122,138,148,168,171,175],immedi:[8,144],immut:[9,90],immutablelist:24,immutableset:25,impact:[53,147,152,202],imperson:[6,9],implement:[1,2,6,8,9,22],implic:37,implicit:[66,69,75,82,144,158,175],implicitli:148,improv:[3,64,65,66,68,70,72,73,76],in_reply_to_screen_nam:13,inaccur:196,inadvert:144,includ:[1,2,8,9,19,25,26,30,35,39,44,47,53,58,62,118,127,129,133,138,144,147,151,152,155,168,179,180,187,202],inclus:[12,120],incompat:[65,66,69,77,82,83,98,104,122,123,127,130,133,134,138,144,145,147,153,156,167,168,176],incomplet:138,inconsist:[53,118,164,202],incorrect:[45,66,72,76,86,87,89,93,100,104,108,109,112,115,116,117,118,119,126,127,128,129,140,154,158,166,167,171,174],incorrectli:[44,113,114,119,123,138,167],increas:[3,8,12,67,71,87,90,103,118,119,138,153],increment:31,indefinit:15,independ:[30,83,114,119,180,202],index_column:6,index_lowest_cardinality_threshold:6,index_metrics_en:6,index_rows_per_split:6,index_threshold:6,indic:[10,25,107,127],individu:[22,24],inequ:164,inexact:58,inf:26,infin:[43,162,168],infinit:[20,43,150,155,175],info:[1,2,13,53,71,85,92],inform:[3,4,6,8],information_schema:[20,98,148,157,162,164,214],infouri:108,infrastructur:[9,152],init:87,initi:[19,24,53,73,90,103,116,119,127,133,148,158,168],initial_splits_per_nod:103,inject:[123,138,147,175],injector:24,inlin:[60,139,215],inner:[66,72,92,96,134,164,202],input:[25,30,31,34,35,38,43,45,48,68,88,101,106,111,116,122,127,128,133,155,158,164,196,202],inputformat:135,inputfunct:25,insensit:[12,30,44,46,93,108,127,158],insert:[6,7,9,10,15,49,65,87,90,96,101,106,108,120,123,153,171,181,197],insid:[11,53,86],inspect:138,instal:2,instanc:[1,2,6,9,15,16,17,22,23,26,27,44,45,53,65,111,118,127,154],instant:[58,144],instead:[2,3,6,8,9,12,16,17,36,44],instruct:[13,86,92,179,180],instrument:[11,139],insuffici:4,integ:[6,9,30,31,33,37,43],integr:13,intend:[21,80,136],intens:180,intention:127,interact:[8,52,62],intercept:30,interchang:35,interest:[22,23,24],interfac:0,intermedi:[67,88,118],interpol:34,interpret:[12,28,43,45,53,114,119,148,168,179,202],interrupt:[65,68,83,96],intersect:[6,31,118],intertwin:147,interv:[8,31],intra:118,introduc:[65,66,80,93,137,138,142,146],intuit:120,invalid:[12,18,36,45,65,66,76,88,101,106,120,123,138,174],invalidrang:66,invent:62,invers:47,investig:4,invok:[23,48,80,179],invokeexact:25,involv:[19,35,67,80,88,90,93,119,128,138,164,167,168],iop:172,ipc:120,iron:13,is_equal_or_nul:25,is_finit:43,is_infinit:43,is_nan:43,is_nul:25,is_partition_kei:98,iscoordin:127,isequalornullfunct:25,isequalornullslic:25,ish:127,isnul:25,isnulldoubl:25,isnullfunct:25,isnulllong:25,isnullslic:25,iso8601:[12,130],iso:[12,13,38],isol:[26,93,213],issu:[3,6,69,72,77,79,87,88,89,90,92,93,96,100,102,104,106,107,108,113,116,119,122,123,127,128,130,138,139,140,145,149,152,158,162,163,164,166,167,168,175,179,180],item:[30,135,138,190],itransportfactori:8,itself:[6,11,12,18,53,60,153],ivhziaperb:13,jackson:26,jan:38,januari:[38,167],japanes:144,jar:[6,13,26,51,52,54,56,138,143,179],java:[6,9,10,11,12,13,25,26,28],javadoc:28,javax:147,jce:[179,180],jdbc:[1,2,16,17,49,50],jdk:[127,165],jersei:[36,202],jmola:13,jmx:[2,3,5],jmxexport:2,job:62,joda:[12,13],jodatim:38,john:35,join:[3,12,16,17,18],join_column:202,join_condit:202,join_typ:202,jose:198,josni:13,journal:15,journal_safei:15,jre:[179,180],json:[1,2,4,10],json_arrai:40,json_array_contain:40,json_array_get:[40,127],json_array_length:40,json_extract:[40,106,153],json_extract_scalar:[13,40,153],json_format:[40,80,81,99],json_pars:[40,80,81,99],json_path:40,json_siz:[40,151,152],jsonmodul:24,jsonpath:40,jul:13,just:[6,20,24,25,97,179,180],k7mdeng:135,kadmin:[179,180],kafka:5,kafka_kei:13,kafka_tpch_0811:13,kdc:[10,179,180],keep:6,kei:[3,6,8,9,10],kept:[7,15],kerber:10,key1:158,key2:158,keyalg:180,keyspac:8,keystore_password:180,keytab:9,keytool:180,keyvaluedelimit:45,keyword:[45,129],kill:[4,19,53,80,96,97,108,184],kill_queri:19,killer:80,kind:62,kindl:13,kinit:180,klist:180,kmsclientprovid:119,know:[28,62,138],known:6,krb5:[10,106,179,180],ktadd:[179,180],kvpyuhcplrb84wgaigv6sypzq7tj:13,label:147,lack:[4,147,168,202],lag:[48,68,77,151,159],lai:[133,152],laid:202,lang:[11,13],languag:[9,28,36,45,49],larg:[22,24,61,62,67,85,90,93,94,95,107,114,119,127,131,137,138,139,140,142,154,156,163,168,171,202],larger:[3,8,45,48,53,66,133,147,153,155,172,179,180],largest:[30,35,80],last:[1,2,9,13,25,31,45,48,101,127,180,202],last_el:60,last_valu:[48,68,77,148],lastli:56,latenc:[96,133,138,139],latent:[102,158],later:[11,12,15,18,60],launch:53,launcher:[13,53],layer:[124,154],layout:[72,147,168,195,196],lazi:[65,102,158],lazybinarycolumnarserd:[133,134],lazyblockload:169,lead:[7,39,45,48,68,77,151,159],leaf:103,leak:[64,66,70,71,77,90,91,98,103,107,110,116,120,123,127,138,144,145,161,168,169,170,173,174],learn:[25,30],learn_classifi:147,learn_libsvm_classifi:148,learn_libsvm_regressor:148,least:[4,8,12,15,18,30],leav:[12,53],lee:6,left:[36,45,60,65,89,202],legaci:[3,9,10,98,117,122,127,129,130,153],legacy_orc:51,legal:60,length:[7,31,32,40,45,46,51,58,93,94,101],less:[6,30,31,35,43,45,52,153],let:55,letter:[127,139,180],level:[8,26,28],leverag:6,lexicod:6,lexigraph:6,lib:6,librari:[25,26,180],libsvm:148,lifecycl:127,lift:6,lightli:82,like:[4,6,7,15,16,17,18,27,28,35,36,37,40,44,52,53,56,60,62,64,67,118,123,128,138,147,152,153,154,175,187,204,210,212],limit:[1,2,8],line:[10,12,24,26,34,44,49,50,51],linear:[30,156],lineitem:[13,51,190,202],linger:8,link:4,list:[2,4,6,8,9,10,11,12,13,15,16,17,18,19,20,22,26,36,38,53,79,85,86,87,88,90,104,117,123,127,130,139,144,147,153,156,179,180,186,187,188,198,202,204,205,208,209,210,211,212],listen:21,liter:[28,38],lithuanian:45,littl:[6,73],live:12,lname:8,loadcommand:13,loader:[13,26,127],local:[3,5,6,8,9,13],local_on:8,local_quorum:8,local_seri:8,localfil:14,localhost:[6,13,52,56],locality_group:6,localtim:38,localtimestamp:38,locat:[2,3,6,9,10,12,13,14,18,53,87,90,106,127,161,162,179,180],lock:[65,86,102,177],log10:43,log2:43,log:[6,9,10,13,14,23,43],logarithm:43,logger:53,logic:29,longanddoublest:25,longer:[6,8,73,92,93,118,133,147,148,153,154,156],look:[6,22,24,25,26],lookup:[6,90],loop:[150,155,175],loos:[30,60],los_angel:[38,58,119,144],lost:107,lot:[138,154],low:[3,6,34,67,80,108,148,190],low_color:34,lower:[25,45,65,71],lowercas:[25,45,46],lowest:[6,12],lpad:[45,107],lreykuwah:13,ltrim:45,lz4:[119,132],machin:[3,9,11,25,30,53,70,133,144],machineri:[13,202],made:[58,138,144,180],magenta:34,magnitud:66,mai:[1,2,3,6,8,9,10,12,15,18,22,25,35,36,41,44,45,53,58,64,66,67,77,83,88,92,96,102,108,122,129,131,133,154,155,158,175,179,180,187,196,202],main:[4,6,12,13,53,65,147,153],maintain:[12,15,18],major:[6,15,133,139,147,153,179,180],make:[1,6,8,9,12],manag:[2,4],mani:[4,8,9,12,15,16,18,19,24,36,45,51,53,60,62,66,88,135,138,152,179,202],manipul:[6,9,184],manner:[7,44,47,127],manual:[15,38,46],map:[6,9,11,12],map_agg:[30,42,65,67,96,129,168],map_concat:[42,94,117],map_kei:[42,158],map_union:[30,119,129],map_valu:[42,158],mapreduc:[9,62,138],march:144,mark:[44,127],market_seg:13,marketseg:13,match:[1,2,9,10,13,14,15,25,28,35,36,44,51,53,81,83,87,89,101,106,107,119,120,128,131,133,138,146,148,153,164,179,180,190,198,202],materi:[9,127],math:[120,122],mathemat:[29,39],matter:[179,180],maven2:13,maven:13,max:[3,8,9,11],max_bi:[30,67,83,86,93,153,164,176],max_initial_split_s:116,max_split_s:[10,116],maxconcurr:1,maxfiledescriptorcount:11,maximum:[2,8,9,11,15,30,31,53,58,74,133,153,158,164,172],maxqueu:[1,2],maxresponses:90,maxrun:2,mayb:187,mbean:[11,119],md5:[32,73],mean:[10,15,25,28,30,35,51,52,128,133,202],meaning:28,measur:[20,51,133],meat:24,mechan:10,median:51,megabyt:[144,171,172],member:[15,40,62],memori:[2,3,4,7,11,53,65,67,68,70,71,72,73,77],merg:[25,31,120,153],mess:6,meta:26,metadata_ag:6,metadata_d:6,metadata_nam:6,metastor:9,method:[6,22,23,24,25,26,28,64,87,93,95,98,123,127,138,144,168,202],methodhandl:[25,135],metric:[6,19,53,66,106,139],mg9kdtd2wbhm:13,micro:133,middl:202,midnight:78,might:[15,128,168],migrat:49,miillisecond:13,milli:12,millisecond:[12,15,28,38,58,65,96,114,119,152,154],min:9,min_bi:[30,67,83,86,93,164],mind:6,minim:[53,104],minimum:[9,15,30,31,53,58,74,131,153,165,179,180],minor:[6,66,93,140,141,148,152],minut:[9,38,46,58,65,148],misinterpret:[114,119],mismatch:119,miss:[12,31,72,108,147,157],mistak:62,mitig:154,mix:[68,130],mktsegment:202,mod:[43,127],mode:[10,15,44,55,83,116,213],model:[60,127,147],modifi:[10,15,133,153],modul:[25,148],modulu:43,mondai:38,mongo:15,mongocli:15,mongod:15,mongodb:5,mongolian:44,monitor:[2,4,11,53,147,180],month:[31,38,46],more:[1,2,4,6,7,8,9,10,12,15,18,22,24,25,28,30,35,52,53,61,66,83,86,87,90,93,96,102,104,120,123,127,135,148,154,155,158,168,190,197,200,202],most:[3,4,9,10,24,25,35,38,45,48,114,119,123,133,144,153,187,209],mount:[6,9,13,16,17,53,132],move:[60,80,119],much:[3,9,24,25,65,67,77,153],multi:[9,44],multimap:30,multimap_agg:[30,42,80,129],multipart:9,multipl:[1,7],murmur3partition:8,must:[1,2,6,9,10,11,12,13,15,17,18,23,25,26,27,30,31,35,40,43,44,45,46,51,53,60,87,135,136,147,179,180,192,198,202],mutat:6,my_arrai:[31,60],my_databas:56,my_password:56,my_suit:56,my_usernam:56,mykeyspac:8,myschema:6,myseri:6,mysql:[5,9],nag:13,name:[1,2,6,7,8,9,10,11],name_to_age_map:42,namenod:[9,96],namespac:[6,144,156],nan:[43,65,162,168],nanosecond:121,narrow:[6,83,180],nation:[7,13,188,195,197,198,200,202],nation_kei:13,nationkei:[7,13,198,202],nativ:[8,25,28,107,147],natur:[43,180],ncwdvawne6tegvwfmrchlxak:13,nearest:[15,43],necessari:[9,13,26,36,37,144],need:[6,8,9,10,12,15,16,18,19,22,25,26,44,53,55,60,65,69,77,83,88,96,98,104,122,123,127,130,133,134,138,144,145,153,167,168,171,174,176,179,180],neg:[15,31,38,40,45,48,77,90,114,119],negat:[39,83],neither:202,nest:[66,88,92,127,161,202],net:[9,16,17,53,54,55],network:[3,4,88],never:[128,166],new_column_nam:183,new_nam:[182,183],new_ord:198,newli:[9,144,186,187,188],newlin:153,next:[1,6,12,56,86,144],nfc:45,nfd:45,nfkc:45,nfkd:45,nobodi:9,noclassdeffounderror:[118,119,129],node:[3,6,8,9,10,11],nodemanag:[127,138],nodeschedul:11,nohostavailableexcept:8,non:[6,8,11,12,25,30,35,36,44,45,65,72,76,83,85,90,93,96,98,104,106,111,115,118,119,120,122,127,128,129,130,131,132],noncharactercodepoint:44,none:[6,9],nor:148,norandkei:[179,180],normal:[4,15,19,30,45,51,52,72,133,144,152,202],nosuchelementexcept:86,notabl:44,note:[6,8,9,12,24,25,35,49,51],noth:97,notif:83,now:[7,13,38,64,67,76,77,80,83,86,87,88,92,93,96,98,103,106,108,117,123,127,129,133,135,138,139,144,145,147,148,151,152,153,154,155,156,158,160,161,164,166,167,168,174,175,176],npe:[67,161],nth_valu:[48,68,77,148,159],ntile:[48,164],null_replac:31,nullabl:[98,127],nullpointerexcept:[96,143,175],num_prec_radix:123,number:[1,2,3,4,6,7,8,9],numer:[6,30,36,37,38,127,138,154,158],numeric_histogram:[30,158],o_orderd:202,oakland:198,object:[6,9,12,15,18,22,24,25,26,28,40,65,67,68,76,77,103,138,171,186],obtain:[24,180],occasion:90,occur:[9,10,30,53,87,92,96,154],occurr:[31,44],odbc:180,off:[90,93,94,97,152,158,161],offlin:148,offset:[12,13,38,48,90,159],often:[62,66,136,138,202],olap:62,old:[8,64,80,99,118,123,131,152],old_ital:44,older:[114,119],oldest:153,oldital:44,oltp:62,omit:[12,18,202],onc:[1,2,15,83,92,104,202],onli:[1,4,6,9,10,12,17,18,23,24,25,35,36,44,51,53,55,60,64,67,72,76,82,87,93,106,116,117,127,133,138,144,147,153,157],onlin:62,onoutofmemoryerror:53,onto:12,oom:[171,172],open:[9,11,19,62],openfiledescriptorcount:11,oper:[6,7,8,9,10,13,15,25],operatingsystem:11,operatordepend:25,operatortyp:25,oppos:[40,106],optim:[6,15,51,62,65,66,68,75,76,80,86,87,88,90,92,94,96,97,101,102,104,106,107,118,120,121,127,129,130,133,135],optimize_hash_gener:[199,203],optimize_index_en:6,optimize_locality_en:6,optimize_metadata_queri:106,optimize_mixed_distinct_aggreg:130,optimize_split_ranges_en:6,optimized_reader_en:[51,157,158,199,203],option:[1,2,3,6,8,9,10,12,15,18,24,27,31,51,52,53,58,65,67,71,72,73,80,83,90,106,107,118,122,127,130],oracl:[62,179,180],orc:[9,51,65,66,76,77,78,88,101,103,106,108,117,119,120,125,127,155],orc_bloom_filters_en:127,order:[6,9,10,13,15,25,26,30,31,43,45,48,53,66,72,74,85,87,93,100,101,106,127,128,134,139,148,153,158,164,166,172,176,187,188,189,190,196,197,198,200],order_d:87,order_id:87,order_info:87,order_region:87,orderd:[15,48,74,134,153,187,188,189,202,206],orderkei:[15,48,187,189,190,202,206],orders3:15,orders_by_d:[134,188,189,193,194],orderstatu:[15,74,153,187,189,206],ordin:[64,65,101,202],ordinalposit:69,org:[8,9,13],organ:[65,180],organiz:180,orient:[155,168],origin:[4,9,19,122,144,195],origin_st:[36,202],origin_zip:[36,202],originalconstraint:196,other:[1,2,4,6,7,8,10,12,18,20,22,23,24,26,27,28,35,44,47,53,55,56,62,64,79,80,93],otherst:25,otherwis:[6,12,27,30,31,36,144,148,190,198],our:[25,133],out:[2,18,19,25,36,39,55],outcom:35,outofmemoryerror:[53,128],output:[4,6,25,31],outputfunct:25,outsid:[9,34,53,77,88,93,180,202],over:[6,15,24,30,48,61,62,69,74,88,90,95,119,120,133,135,137,140,144,148,153,154,157,162,168,179,180,189],overal:103,overflow:[116,127,138,144],overhead:51,overrid:[9,24,25,26,156],overridden:[13,52],overwritten:6,own:[6,9,10,26,184],owner:[10,83,123],ownership:10,p332a:36,p4hyperloglog:93,pacif:70,pack:6,packag:[6,13,26,36,53,73,90,127,138,148,149],package_weight:202,pad:[34,45,107,202],padstr:45,page:[4,6,7,18,55,65,68,72,93,97,99,101,103,107,108,110,116,127,129,154,158,168],page_processing_delai:[7,127],page_url:9,page_view:9,pager:[83,96],pages_per_split:7,pagetoolargeexcept:90,pagin:52,pair:[6,12,18,30,44,45],parallel:[4,8,30],paramet:[9,18,19,24,25,28,34,35,43,47,55,58,67,90,122,128,144,148,166],parametrictyp:[26,28],parent:[2,147],parenthes:202,parenthesi:38,parquet:[9,65,68,79,83,90,101],parquet_optimized_reader_en:102,parquet_predicate_pushdown_en:102,pars:[12,13,38,40,46,58,90,105,114,118,119,121,144,153,154,161],parse_datetim:38,part:[6,9,12,13,15,18,25,39,58,60,127,136,144,147,153,202],parti:[62,143],partial:[25,72,75,83,158,168,176,195,196],particular:[6,10,18,22,24,26,28,37,53,55,60,77,153,154,168,202],particularli:[93,202],partion:8,partit:[8,9,12,13,22,24,48,49,65,66,67,68,72,73,74,75,87,90,96,98,101,104,107,108,110,116,118,119,127,128,131,133,134,138,140,144,148,153,154,155,156,157,158,163,168,174,181,195,196],partition:8,partitioned_bi:[9,87,206],partitionresult:144,partsupp:13,pass:[6,8,9,23,27,34,76,179],password:[6,8,15,16,17],path:[9,10,47,53,54,67,81,118,123,127,133,153,179,180],pattern:[14,38,44,83,204,210,212],paul:35,paus:65,peak:101,peer:[8,48],penalti:2,pend:[13,119,127,131,153],peopl:183,pequitamedicen:13,per:[1,3,6,8,9,10,12,13],per_packag:36,perceiv:[45,66],percent_rank:48,percentag:[2,4,30,48,88,202],percentil:[30,101],perform:[3,7,9,10,12,15,18,19,20,23,25,27,38,39,43,44,45,48,51,53,58,60,65,66,68,74,76,83,88,90,93,94,95,96,97,98,104,106,107,108,116,118,119,120,122,123,125,127,128,130,133,135,139,140,144,147,148,151,152,153,154,155,160,163,164,184,202],period:[2,11,119],perman:69,permiss:[9,10,27,83,119,127,168],permit:[1,10],permut:31,persist:4,person:[1,2],perspect:62,petabyt:62,phase:107,phone:13,physic:[12,65,90,202],pick:[6,26,154],pig:[62,202],pin:[9,93],ping:120,pinto:13,pipe:6,pipelin:[1,2,62],pipeline_:2,place:[2,13,26,31,43,176],place_nam:13,placehold:10,placement:168,plan:[4,65,72,73,77,82,85,88,90,96,100,101,102,103,106,118,119,127,128,131,140,145,148,153,154,156,160,163,167,168,175,195,196],planner:[67,93,111,116,141,144,168,174],platelet:13,pleas:[6,9,15,18,147,148,156],plu:[48,65,187],pluggabl:[2,6],plugin:[2,6,9,15,21,22,23],point:[8,9,24,26],pointer:82,poland:198,polici:[1,2,8,119,154,168,175],poll:154,pom:26,pool:[13,15],poor:95,popul:30,popular:35,port:[4,8,9,12,13,15,18,47,53,54,55,119,123,155,179,180],portion:133,posit:[12,15,31,43,45,65,72,90,101,114,119,184,202],possess:[197,200],possibl:[4,8,9,10,12,18,30,37,65,67,88,90,97,120,133,175,179,180,202],post:88,postgresql:5,potenti:[4,66,68,108,110,116,118,120,123,127,128,130],pow:[43,79],power:[6,43,79,127,202],practic:[6,10],pre:[68,88,99],precaut:10,preced:[48,92,113,119,202],precis:[39,58,83,121,127],precomput:177,predic:6,prefix:[6,9,13],preload:13,prematur:70,prepar:[127,128],preregistr:156,presenc:35,present:[12,18,67,108,198,202],preserv:[44,53],press:83,pressur:[160,162],presto:[0,1,2],presto_hom:6,presto_keystor:180,presto_offlin:148,presto_pag:52,presto_query_id:127,prestobatchwrit:6,prestoconnect:[144,156],prestointerv:[114,119],prestos3filesystem:[65,66,68],pretti:12,prevent:[10,76,85,93,95,99,123,127,132,138],previou:[1,6,25,56,65,69,77,83,90,98,104,122,123,127,130,133,153,167,168,171,176],previous:[6,65,76,78,83,92,101,114,119,120,123,138,144,147,153,154],price:[48,134,188,189],primari:[6,8,15,24,56,132],primarili:7,primary_pref:15,primit:[12,25],princip:9,print:[38,72,77,83,144],printadaptivesizepolici:3,printclasshistogramafterfullgc:3,printclasshistogrambeforefullgc:3,printflsstatist:3,printgcapplicationconcurrenttim:3,printgcapplicationstoppedtim:3,printgccaus:3,printgcdatestamp:3,printgcdetail:3,printgctimestamp:3,printreferencegc:3,printsafepointstatist:3,printsafepointstatisticscount:3,prior:180,prioriti:[2,190],privat:10,privileg:[10,197,200],probabl:[27,180,202],probe:[67,103],problem:[3,9,114,119,138,179,180],procedure_nam:184,process:[1,2,3,4,6,9,10,13,18,19,22,24,48,51,53,62,64,88,94,108,111,118,120,131,135,138,147,148,158,179,180,202],processcputimemean:51,processcputimep50:51,processcputimestd:51,processing_optim:120,produc:[7,12,13,28,30,35,36,38,48,53,60,62,72,73,76,80,88,92,96,104,108,115,120,122,127,128,129,138,144,158,166,167,198,202],product:[53,147,202],program:[13,51,52],programat:6,programmat:6,progress:[65,67,101,119,156,158],project:[6,51,62,68,90,94,148,179,180,196],prompt:180,proof:147,prop:44,propag:[135,138],proper:[6,9,138,152],properli:[6,7,72,77,93,97,129,133,138,164],properti:1,property1:[23,27],property2:[23,27],property_nam:[186,187,188],proport:2,prospect:62,protocol:[8,9,47,179,180],provid:[4,6,8],provinc:180,provis:9,prune:[107,158],pseudo:43,publish:138,punctuat:46,purpos:[12,62,132],push:[6,65,68,90,102,117,119,127,138,158],pushdown:[6,102],put:[1,2,6,12,13,18,62,92],pwd:13,q3rqzlzct1:13,quadrat:66,qualifi:[6,9,12,18,53,83,116,133,135,184],qualiti:12,quarter:[38,189],queri:[1,2,3,4,6,7],query_max_memori:71,query_max_run_tim:80,query_prior:2,querycompletionev:104,querycputimemean:51,querycputimep50:51,querycputimestd:51,queu:[1,2,4,8,19,73,120,127,138,158],queue:0,quickli:[6,196],quit:12,quorum:[8,13],quorumpeerconfig:13,quot:[11,53],quota:[1,2,121],race:[70,79,87,88,97,104,107,111,118,121,124,138,155,156],radian:[43,64],radix:43,rais:[39,43,96,189],ran:[19,51],rand:[43,139],randkei:[179,180],random:[31,43,96,179,180,202],randomli:[72,121],randompartition:8,rang:[6,8,30,34],rank:30,rankingwindowfunct:123,raptor:116,rare:[98,103,104,127,148,167],rate:7,rather:[9,25,30,44,64,72,78,93,96,113,114,118,119,122,123,127,148,154,168,189],ratio:6,raw:4,raw_dat:13,rcbinari:[9,152,154],rcfile:[9,127,130,133,134,144,150,154,157,159],rcfile_optimized_reader_en:127,rctext:152,reach:[2,108,179,180],reactj:65,read:[6,7,8,9,10,12,13],readabl:[10,51,76],reader:[51,76,77,78,79],readi:[26,147],readm:[6,136,179,180],readonlyconnectormetadata:134,real:[9,24],realm:[179,180],realtim:120,reboot:53,receiv:[6,53,83,92,133,153],recent:[4,19,144,209],reclaim:[96,147],recogn:44,recommend:[9,12,13,15,53,134,147,154,179,180],reconnect:144,record:22,recordcursor:22,recordcursorprovid:153,recordkei:6,recordread:135,recordset:22,recordsink:168,recreat:[118,127],recurs:[65,148],red:[34,156],redi:5,redirect:180,redistribut:[3,73,103,155],redistribute_writ:73,reduc:[6,9,15,18,65,67,68,88,90,102,119,128,129,131,138,144,148,158,162,171,172,177,179,180,202],reduct:133,redund:[88,101,104,141],reenabl:71,refactor:[147,153],refer:[8,9,12,15,18,24,28,46,58,60,88,89,106,111,116,164,169,171,202],referenc:[9,11,40,44,64,107,123,176,189,202],reflect:93,reformat:51,refresh:[8,65,71,77,85],refus:15,regardless:[8,10,202],regex:[2,10,119],regexp_extract:44,regexp_extract_al:[44,168],regexp_lik:44,regexp_replac:44,regexp_split:[44,65],region:[9,13,83,93,202],regionkei:[195,198,202],regist:[23,27,53],regr_intercept:[30,68],regr_slop:[30,68],regress:[30,85,93,94,98,107,108,118,122,123,127,128,131,135,138,140,142,144,146,155,160,161,164],regressor:147,regular:[9,13,29],reintroduc:80,reject:[1,2,79,120],rel:[26,45,196,214],relat:[19,22,62,65,89,144,154,202],releas:[1,49,56],relev:[6,25,26,53],reli:[6,7,179,180],reliabl:[116,139],remain:[23,27,53],remaind:[34,43,48],rememb:60,remot:[8,94,154,162,168,179],remote_task_error:104,remotesourc:[195,196],remov:[10,15,31,44,45,64,65,66,67,69],renam:[10,51,52,56,64,65,66,67,83,106,118,120,123,127,131,144,153,176,182,183],render:[34,55,58,66,116,121,127,164],repartit:[91,110,116,195],repeat:[154,213],repeatedli:120,replac:[6,8,9,12,15,16,17,18,31,44,45,53,55,62,83,103,118,123,127,144,157,167,189],replic:[8,30,147],replica:8,replica_acknowledg:15,replicas_saf:15,replication_factor:8,repo1:13,report:[15,24,51,62,96,106,118,123,129,133,138,140],repositori:6,repres:[12,15,18,43,65,144],represent:[4,30,32,33,39,43,45,46,77,167,176],reproduc:138,request:[8,9,13,14,15,53,67,68,85,92,93,106,127,128,138,154],request_log:9,request_tim:9,requir:[2,3,6,8,9,10,12],requiredconfig:24,research:30,reserv:[1,3,67,77,129],reset:[49,90,93,128,168,181],resid:6,resolut:116,resolv:[129,164,214],resourc:0,resource_overcommit:[96,108],respect:[6,9,55,60,106,107,139,148,154],respons:[10,22,23,24,27,65,77,83,105,179,180],rest:[9,45,65,114,119,120],restart:[6,7,13,26,97],restor:[83,122,132],restrict:[153,202,204,210,212],result:[6,9,10,12,15,25,28,30,35,36,38,39,40,41,42,45,48,52,55,60,66,72,74,76,80,83,86,87,88,89,93,100,101,104,108,109,112,115,116,118,119,120,122,126,127,128,129,133,134,138,144,148,149,152,153,155,158,164,166,167,168,174,188,202],resultset:[65,75,87],retain:171,retent:[68,171],retention_dai:[93,101],retri:[8,9,66,67,68,85,116,119,127,152,154,158,168],retriev:[6,9,15,26,42,55,156,202],returntyp:25,retweet_count:13,revers:[31,45,123,209],revert:152,revok:[10,16,17,49,119,127,181,197],rewrit:[102,133,158],rewritten:[65,66,139,202],rfc2822:[12,13],rfc:[12,13,47],rgb:34,right:[3,36,45,60,65,66,73,89,127,164,202],ringo:35,rmi:53,rmiserv:53,rnk:48,roadmap:133,role:[9,197,200],roll:[48,119,144],rollback:[49,65,181,185],rolling_sum:48,rollup:[106,202],root:[6,16,17,24,25,26,43],rootgroup:2,rotat:[9,53],round:[43,121,127],row1:6,row2:6,row3:6,row:[6,7,8,11],row_id:6,row_numb:[13,48,65,72,74,76,148,153,158,166],rownumb:13,rows_per_pag:7,rpad:[45,107],rpm:[73,87],rsa:180,rtrim:[45,120],rule:[1,2],run:[1,2,4,8,9,10,11,12,13,14,15,16,17,19,25,27,48,51,52],runningsplit:3,runtim:[6,11],s3a:[9,65],s3bf:9,s3n:9,s3signertyp:9,safari:99,safe:[32,47],safer:133,safeti:77,sale:[8,9,12,15,16,17,54,186,192],same:[3,6,7,9,10,11,12,15,20,24,30,31,35,38,39,43,45,48,53,72,83,101,106,113,119,120,123,129,131,133,144,147,168,174,179,180,187,188,197,202,209],sampl:[11,13,25,30,119,129,147,202],san:198,sasl:10,sat:38,satisfi:202,saturdai:38,save:144,scalarfunct:[25,123],scale:[20,39,51,58],scan:6,scan_auth:6,scan_usernam:6,scanner:6,scenario:154,schedul:[3,9,11,53,65,66,83,85,87],schedulingpolici:2,schedulingweight:2,schema1:18,schema:[6,8],schema_nam:[18,186,192],schemaexist:127,schemanam:[12,13,18],scheme:65,scientist:6,scientists_idx:6,scientists_idx_metr:6,scope:[26,127],score:[60,202],scp:6,screen:93,screen_nam:13,script:[44,53,80,87,133,179],sdk:[9,139],search:[6,36,45],second:[1,2,7,8,9,12,13,31,38,46],secondari:[6,15,87],secondary_pref:15,secret:[6,9,13,16,17,135],section:[4,6,9,10,12,15,38,46,47,62,179,180],secur:[5,9],securityexcept:166,see:[2,6,9,10,11,12,13,14,16,17,18,22,25,26,28,42,43,52,53,58,77,82,86,93,104,123,127,132,133,135,136,147,148,153,156,158,175,180],seek:[65,66],seen:[25,51,132],segment:[12,13,153,202],select:[2,4,6,7,8,9,10,11,12,13,15,16,17,18,19,31,33,35,36,37,38,40,41,42,43,44,48,49,51,52,60,72,74,87,88,90,100,119,122,130,133,134,135,138,139,144,147,148,153,158,159,167,175,181,186,187,188,189,190,195,196,197,198,200],select_expr:202,self:[12,52,179],semant:[60,80,90,202],semaphor:136,semi:[75,81,152],send:[13,180],sens:62,sensit:[10,44,45,107,164],sent:88,separ:[8,9,11,12,15,18,24,26,27,45,47,48,66,102,147,156,158,171,184],sequenc:[12,31,45,48,118,120],sequencefil:[9,152],sequenti:[1,2,48],serd:[133,134,144],serializ:213,serv:[9,132],server:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15],serverinfo:127,servic:9,serviceload:26,session:[2,3],sessionproperti:10,sessionpropertymetadata:77,set:[1,2],setdoubl:25,setlocal:144,setlong:25,setnodemanag:138,setoptionalconfig:127,setreadonli:72,setrequiredconfigurationproperti:24,setsessionproperti:156,setter:25,settimezoneid:144,setup:9,sever:[20,27,114,119,144,151],sf0:195,sf100000:20,sf10000:20,sf1000:20,sf100:20,sf1:[20,196,206],sf30000:20,sf3000:20,sf300:20,sha1:[32,79],sha256:[32,79],sha512:[32,79],shadow:[122,123],shape:[13,68,76,153],shard:[15,64,161],share:[53,90,123,171],shell:[6,15,52,53,133],ship:[28,36,88,179,180,190,202],shipmod:190,should:[1,2,3,4,6,9,10,12,13,15,18,22,26,30,34,53,72,84,88,121,123,133,135,144,147,152,153,154,155,168,169,180,197,200],shouldn:7,show:[6,11,12,13,14,16,17,18,19,20,49,66,77,93,98,118,132],shown:[12,34,35,41,133,202],shuffl:[8,31,127],shutting_down:92,side:[3,6,9,41,55,66,73,83,93,96,103,133,138,164,202],sign:[12,33,43,44,58,88,114,118,119,127,167],signatur:28,signer:[9,127],signifi:35,signific:133,significantli:[144,153],signum:43,silent:[10,93,115,127,168],similar:[24,25,26,43,44,48],similarli:118,simpl:[10,12,18,22,24,25,36,129],simplest:[179,202],simplestrategi:8,simpli:[4,6,8,9,12,15,16,17,18,22,25,138],simplifi:[6,53,153,156,202],simul:13,simultan:9,sin:43,sinc:[7,12,13,28,62,133,138,144,167,171,202],sine:43,singl:[2,6,8,12,14,17,18,22,23,24,25,26,30,31,34,45,53,60,66,67,76,81,127,131,133,171,172,195,196,198,202,215],single_:51,single_bigint:51,single_varchar:51,site:[9,10],situat:[3,10,67],size:[6,8,9,11],skew:[4,73,127],skip:[72,76,83,117,119,120,202],skzz0csnmd7mp4xd0yrbvx:13,slash:[12,53],sleep:13,slice:[13,25,26,31,73,107,168],slide:48,slightli:90,slope:30,slot:1,slow:[7,67,133],slower:[3,147],slowli:[148,168],slyli:13,small:[20,93,144,148,153,171,172,175],smaller:[35,90],smallest:[30,35,80],smallint:9,smile_kidrauhl6:13,snappi:[51,132],snapshot:11,sock:[77,171],socket:[8,9,13],softcpulimit:2,softmemorylimit:2,softwar:[9,11],softwareforg:13,sole:15,solut:[179,180],solv:180,some:[6,7,9,12,20,25,28],someth:22,sometim:[3,133],someus:179,soon:[73,138,164],sooner:70,sort:[31,43,65,97,120,202,209],sourc:[1,2,4,5,20,22,24,25,26,36,53,55,61,62,65,70,108,111,118,119,129],space:[3,4,10,34,44,47,53,120,138,155],span:[58,144],spanish:144,spars:43,spec:60,special:[6,12,15,38,45,48,53,64,153],specif:[3,8,9,10,12,23,27,30,34,45,48,53,77,87,104,106,117,123,127,128,133,138,139,153,154,156,166,180],specifc:12,specifi:[1,2,3,4,6,7,9,10,11,12,15,19,24,25,27,30,34,35,36,38,40,43,44,45,46,47,48,53,58,64,78,80,83,87,90,96,107,114,119,122,127,135,144,154,161,166,179,180,187,190,197,198,200,202,206,207,214],speed:[65,148,175],spent:[4,129,196],spi:21,split:[3,4,6,8,9,22,23],split_concurrency_adjustment_interv:103,split_count:7,split_part:45,split_to_map:[45,119],splitsourc:144,splittabl:[65,136],sporad:96,spuriou:[127,155],sql:[6,10,12,16,17,19,24,25,28,31,35,36,38,45,46,49,51,55],sqlexcept:168,sqlnullabl:[25,127],sqltask:[82,156,174],sqltype:25,sqrt:43,squar:[43,153],srednekolymsk:70,sse:[9,93],ssh:10,ssl:9,stabil:148,stack:[93,180],stage:[4,9,67,70,101,103,108,117,118,120,121,127,131,173,196],standalon:138,standard:[10,11,12,20,26,30,31,35,36,38,39,45,51,58],standardtyp:25,start:[1,2,4,6,8,9,12,13,26,31,38,45,46,48,49,53],startup:[15,53,70,73,102,107,132],starvat:[108,153],stat:[3,65,75,88,96,98,100,120,123,127,131,147,148,158,174,196],state:[1,2,4,25,53,68,70,92,132,180],statement:[6,16,17,35,49,87,93,97,108,127,128,133,139,148,153],statementcli:[68,83],statementresourc:174,statementstat:120,statist:[2,4],statu:[19,72,83,127],stddev:[30,139],stddev_pop:30,stddev_samp:30,stderr:[13,53],stdout:[53,180],sticki:97,still:[6,9,12,18,77,131,136,155],sting:18,stochast:2,stop:[31,119,138,153],stopgap:136,storag:[9,107,127,147],storage_format:156,store:[6,8,9,10,11,14,15,18,25,28,40,53,68,147,148,153,154,180,184,189],str_to_dat:38,straightforward:22,strang:12,strategi:[12,22],stream:[30,53,65,73,83,91,108,129,153],strengh:[179,180],strength:[179,180],strictconfig:24,strictli:2,string1:45,string2:45,string:[2,6,9,12,13,15,18,24,25,29,31,32,34,35,38,40,43,44],stringn:45,stringy_scientist:6,stripe:[88,120,175],strpo:[45,46],struct:[65,138,160,175],structur:[58,67,77,86,90,92,93,127,161],stsassumerolesessioncredentialsprovid:9,stssessioncredentialsprovid:9,student:[60,202],style:34,sub:[2,6,96,111,116],subclass:123,subdirectori:148,subgroup:2,subject:[1,2,147],sublist:202,submit:[1,2,10,55,73,88,92,144,158,174],subnetutil:118,subproject:6,subqueri:[35,60,101,106,107,127,128,130,131,164],subset:[6,12,31,55],substag:173,substanti:[3,135,136,153],substitut:10,substr:[44,45,46,60,106],subtot:202,subtract:[38,43],succe:[138,197,200],success:[23,88],successfulli:[72,119,180],suffici:[10,25],suffix:[38,127],suggest:102,suitabl:147,sum:[13,25,30,48,51,130,134,188,189,202],summar:[138,188,189],summari:[4,99],sun:38,sundai:38,superus:10,supervis:53,suppli:[20,34,138],supplier:13,support:[1,2,6,8],suppress:[186,187,188,192,193,194],sure:[6,8,9,12,15,16,17,18,114,119,153],surrog:44,surround:202,swap:142,symbol:128,symlink:[111,117,118],syntax:[20,35,38,39,44,45,47,48,49],synthet:[138,148],system:[5,7,9,10,14,15,16,17,18],systemaccesscontrol:[26,27],systemaccesscontrolfactori:27,tab:90,tabl:3,table1:[12,18],table2:[12,18],table_nam:[15,18,187,188,190,191,193,197,198,200,202,206],tableau:[49,50],tablehandl:144,tablelayout:98,tablenam:[12,13,18],tablescan:[195,196],tablet:6,tabletserv:6,tabletserver_address:6,tag:51,take:[2,6,9,10,12,25,30,58,76,80,90,93,130,146,148,151],taken:[11,111,116],talk:[119,152],tan:43,tangent:43,tanh:43,tar:53,tarbal:[53,148,149],task:[3,4],task_aggregation_concurr:[67,118],task_concurr:118,task_default_concurr:67,task_hash_build_concurr:[67,118],task_intermediate_aggreg:[88,118],task_join_concurr:[67,118],task_share_index_load:90,task_writer_count:66,taskexecutor:[3,177],tbl:6,tcge5gazngvepxu5krrvxbfkasdtea:13,tcp:9,tear:143,teardown:[64,107,138],telnet:180,templat:[1,2],tempor:144,temporari:[9,67,77,118,122,147],ten:[87,148],tend:6,terabyt:62,teradata:[25,29],term:[38,164,197,200],termin:[8,44,52,53,83,116,166],test:[7,13,20,35,53,56,60,82,88,100,102,116,138,148,158,171,184,189,200,202],test_catalog:56,test_password:[56,171],test_postqueri:[56,88],test_prequeri:[56,88],test_queri:56,test_schema:56,test_usernam:[56,171],testraptordistributedqueri:148,text:[4,8,9],textfil:[9,152],textual:12,tez:9,tha:43,than:[1,2,3,8,9,23,25,27,30,31,35,43,44,45,48,64,72,78,79,83,86,87,90,93,96,100,104,113,114,118,119,122,123,126,127,129,133,148,154,155,168,179,180,189,202],thei:[1,2,6,8,10,12,18,19,23,26,35,48,55,80,83,89,103,108,144,148,198,202,209],them:[2,7,9,10,11,15,25,26,28,60,92,121,144,154,156,179,180,209],theodolit:13,therefor:60,thi:[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,30,31,34,35,37,38,40,43,44,45,46,47,48,51,52,53,55,58,60,62,64,65,66,67,69,71,73,76,77,82,83,84,86,88,90,92,93,94,96,97,98,101,104,108,114,116,119,121,122,123,127,130,133,134,135,136,138,142,144,145,146,147,148,151,152,153,154,155,156,158,161,167,168,169,171,172,176,179,180,181,196,202],thing:[13,24],think:[6,77],thinli:13,third:[62,143],thoroughli:6,those:[11,15,93,179,180,197,200,202],though:6,thousand:[148,160],thread:[3,8,13,15,56,64,65,67,68,83,119,127,142,154,172],three:[1,2,8,9,10,34,48,202,215],threshold:[6,76,87,128],thrift:[8,9],thrifthivemetastor:123,throttl:85,through:[9,13,15,153,179,180],throughput:[3,6,80,103],thu:[10,17,26,27,48,53,93,146,184,202],ticket:[9,180],tie:[48,154],tightli:202,tim:6,time:[2,4,6,8,9,11],timelin:[4,68,107],timeout:[8,9],timestamp1:38,timestamp2:38,timestamp:[6,9,11,12,13,31,35,38,46],timestamp_column:144,timestampwithtimezonetyp:28,timezon:[28,90,130,148],timezone_hour:[38,152],timezone_minut:38,tini:[7,13,20,88,195],tinyint:9,tion:13,tls_rsa_with_aes_128_cbc_sha256:180,tls_rsa_with_aes_128_cbc_sha:180,tmp:179,tmpdir:9,to_bas:[43,64],to_base64:32,to_base64url:32,to_char:[46,72],to_dat:[46,72],to_hex:32,to_iso8601:[38,72],to_timestamp:[46,72],to_unixtim:38,to_utf8:[45,66],todai:6,togeth:[1,2,8,25,35],toggl:[65,83,90],token:[8,13],tokenawarepolici:8,tolowercas:25,tom:30,too:[22,73,83,95,142,152,154,164,168],tool:[6,13,62],top:[4,26,53,65,74,129,139,153,215],topic:12,topicnam:[12,13],topolog:[3,8],torn:[127,138],tostringutf8:25,total:[2,6,13,48,51,58,67,77,127,202],total_cost:36,totalb:202,totalpric:[15,48,134,187,188,189,206],tov:30,tpc:[20,138],tpch:[5,7,13],tpch_:51,tpch_sf100_orc_non:51,tpch_sf100_orc_snappi:51,tpch_sf100_orc_zlib:51,tpch_sf:51,trace:[6,93,180],track:[25,67,88,98,101,120,139,164],trade:93,tradit:62,traffic:[182,186],trail:[39,44,45],train:147,training_data:147,transfer:[15,135],transform:[45,122],transit:144,transport:[8,25,95,123,144],treat:[6,12,18,33,35,44,45,60,65,66,93,114,119,144],tree:[24,26,30],tri:15,trigger:[92,128],trim:[45,72,120],tripl:6,trivial:154,true_valu:36,trump:6,truncat:34,trunk:[51,56],truststor:127,truth:[35,41],try_cast:[37,127,152,172,174],tsv:51,ttl:[8,128],tue:13,tune:0,tupledomain:92,ture:6,turkish:45,turn:[2,13,22,24,75,94,97,130,144,158,161],tutori:5,twice:66,twistr:13,twistr_kafka_0811:13,twitter_fe:13,two:[4,6,8,9,10,11,12,16,17,25,28,30,36,38,42,51,56,58,60,65,83,113,119,127,135,138,148,153,154,179,180,202,215],type:[6,8],typemanag:123,typeparamet:25,typic:[6,9,15,47,53,102,144,158,179,180],ud800:44,udc00:44,unaccept:180,unacknowledg:15,unathent:180,unauthent:180,unauthor:10,unbalanc:138,unbound:[48,113,119],uncommit:213,uncommon:9,uncompact:12,uncorrel:[122,128],undefin:35,under:[10,14,62,71,148,156],underli:[8,22,25,65,127,156,202],underscor:[44,92,138,153,174],understand:[6,24,26,62,65],unescap:47,uneven:31,unexpect:[80,104,144],unfortun:[15,133],unicod:44,unimpl:168,union:[30,31,35,42,65,75,82,83,93,106,119,120,138,153,156,164,167,168,175],uniqu:[4,48,53,144,202],unit:[38,43,45,66,144,180],unix:[7,28,38,52],unixtim:38,unknown:[35,101,168,180,196],unless:[2,134,156,202],unlik:[25,60],unnecessari:129,unnecessarili:104,unpack:53,unparenthes:168,unpartit:[90,119,134],unqualifi:[12,18,180],unreach:68,unrecover:[118,144],unreferenc:176,unresolv:96,unsecur:10,unsent:8,unstructur:13,unsupportedoperationexcept:168,until:[1,36],unus:[148,149],unwind:13,unwrap:156,updat:[6,13,65,66,69,77,83,98,104,114,118,119,122,123,127,130,133,134,138,144,145,153,158,167,168,171,172,176,179,180,214],upgrad:[53,68,88,132,144,171],upload:9,upper:[30,45,71,96,127,139],uppercas:[45,47,106],uptim:11,uri:[9,24,47,53,132],url:[9,16,17,29,32],url_decod:[47,77,123],url_encod:[47,77],url_extract_frag:47,url_extract_host:47,url_extract_paramet:47,url_extract_path:47,url_extract_port:47,url_extract_protocol:47,url_extract_queri:47,usag:[2,3],useg1gc:53,usegcoverheadlimit:53,useless:93,user:[1,2,6,8,9],user_ag:9,user_id:[8,9,183],user_nam:13,user_pipelin:1,userid:60,usernam:[4,6,8],usual:[6,15,25],utc:[38,119],utf8slic:25,utf:[12,45,46,47,66,120],util:[3,6,13,24,25],uuid:[9,72,132],valid:[6,24,45,47,64,66,73,77,90,101,127,152,164],validation_data:147,valu:[2,6,7,8,9,10,11,12],value1:[23,25,27,35,36],value2:[23,25,27,35,36],valuewindowfunct:123,var_pop:30,var_samp:30,varbinari:[30,32,45],varchar:[6,7,8,9,12,13,15,18,25,28,31,32,34,35,37,38,40,43,44,45,46,47,56],varchartyp:28,vari:[9,20,34,38,179,180],variablewidthblockencod:176,varianc:[30,139],variant:[30,93,96,130],variou:[4,6,18,24,25,26,96,122,129],vast:62,vector:[43,102,158],verbos:[53,158],veri:[11,20,24,53,60,108,138,175],verifi:[10,13,27,49,50],verifiableproperti:13,verifier_queri:[56,88,171],versa:[37,60],version:[6,9,11,13,26,53,65,66,83,90,96,114,119,127,130,131,136,138,142,152,165,168,179,180],via:[2,3,4,6,7,8,9,11,19,24,25],vice:[37,60],view:[16,17,49,60,65,80,83,94,101,116,118,123,127],view_nam:[189,194,207],view_tim:9,virtual:[11,53],visibl:[19,45,66],visual:[4,68,100,107,142,158],vmname:11,vmversion:11,wai:[7,15,35,51,88,147,179,209],wait:[4,8],wake:13,wall:[51,67,102,127,158,196],walltimemean:51,walltimep50:51,walltimestd:51,want:[6,17,25,55,60,134,179,180],wareh:62,warehous:[9,10,158],warm:51,warn:[53,119],web:0,week:38,week_of_year:38,weekdai:38,weigh:30,weight:[2,30],weird:135,well:[3,6,9,18,196,197,200],were:[12,18,19,60,67,76,83,111,114,116,119,120,123,133,138,140,153,154,162,168],what:[6,25,26],when:[1,2,3,6,7,8,9,10,11,12,15,18,19,20,22,25,26,27,30,35,36,37,38,44,53,55],whenev:[26,135],where:[4,6,9,13,14,15,19,25,36,38,47,48,60,72,74,77,79,81,85,87,88,89,90,100,106,111,116,119,122,127,130,133,144,153,155,158,161,162,164,165,167,168,175,180,190,195,202,209,213,215],wherea:[3,60],whether:[10,12,15,18,27,35,60,90,144,202],which:[1,2,4,6,9,10,11,12,13,15,18,20,22,23,24,25,26,27,28,30,31,34,35,45,48,51,52,53,60,65,66,67,68,69,73,77,79,87,88,90,93,96,97,100,102,103,104,109,116,117,119,121,122,123,124,127,128,132,136,138,144,148,152,153,154,155,156,157,158,164,168,179,180,187,196,202],white:[8,34],whitelist:127,whitelistpolici:8,whitespac:45,who:[8,10,19,27],whole:60,whose:[131,156,162],why:202,widen:9,width:[12,34,43,83],width_bucket:[43,107],window:29,windowfunct:123,wise:31,wish:[6,9,53],with_queri:202,within:[2,6,10,12,13,15,17,18,34,35,44,48,64,90,148,202],without:[9,12,13,18,20,24,25,28,31,36,44,51,58,69,79,83,123,133,134,136,138,148,154,158,198,215],wjalrxutnfemi:135,word:44,work:[3,6,7,9,10,13,24,25,35,39,53,62,64,67,77,82,118,133,135,138,144],worker:[3,4,6,10,12,14,22,24,25,26,53,64,67,68,77,92,97,119,123,127,131,133,138,147,152,154,168,180],workload:[3,62,138],world:35,wors:155,would:[10,26,27,48,53,56,83,90,92,101,113,119,127,128,133,138,146,147,148,153,162,167,171,172],wrap:[23,27],wrapper:[6,25,179],write:[6,7,8,9,10,12],writedoubl:25,writer:[9,66,104,119,127,168],written:[7,8,9,14,53,65,69,77,83,98,104,122,123,127,130,133,134,138,145,147,153,167,168,176],wrong:[90,114,119,122,133,146,165],x00:6,x00g:6,x00m:6,x06:6,x08:6,x7f:6,x80:6,xa6:6,xad:6,xed:6,xff:6,xkiaftjuscuxfelenqefumtrj:13,xml:[9,10,26],xmx16g:53,xor:33,xstf4:13,xxvsjslagtn:13,xxx:6,xxxxxxx:39,yael:30,year:[31,38,46],year_of_week:[38,168],yellow:34,yet:[6,9,13,16,17,58,98,136,180],york:202,you:[3,6,7,8,9,10,11,12,14,15,16,17,18,19,20,22,24,25,26,28,35,44,53,55,56,60,62,65,69,77,80,82,83,87,88,98,102,104,121,122,123,127,130,133,134,138,144,145,147,153,154,156,158,167,168,171,176,179,180,196,202],younger:6,your:[3,6,8,9,10,13,15,16,17,22,54,55,60,65,69,77,80,83,88,93,98,101,104,121,122,123,127,130,133,134,135,138,145,147,148,152,153,158,167,168,171,176,179,180],yow:38,yvn:13,yyyi:46,yyyyyyi:39,z123:44,zero:[7,8,10,30,36,39,40,48,65,72,77,83,138,139,202],zip:[31,119,179,180,183],zkcli:6,zlib:51,znode:6,zone:35,zookeep:[6,13],zookeepermetadatamanag:6,zset:18},titles:["4. Administration","4.3. Queue Configuration","4.4. Resource Group Configuration","4.2. Tuning Presto","4.1. Web Interface","5. Connectors","5.1. Accumulo Connector","5.2. Black Hole Connector","5.3. Cassandra Connector","5.4. Hive Connector","5.5. Hive Security Configuration","5.6. JMX Connector","5.7. Kafka Connector","5.8. Kafka Connector Tutorial","5.9. Local File Connector","5.10. MongoDB Connector","5.11. MySQL Connector","5.12. PostgreSQL Connector","5.13. Redis Connector","5.14. System Connector","5.15. TPCH Connector","10. Developer Guide","10.2. Connectors","10.7. Event Listener","10.3. Example HTTP Connector","10.5. Functions","10.1. SPI Overview","10.6. System Access Control","10.4. Types","6. Functions and Operators","6.14. Aggregate Functions","6.17. Array Functions and Operators","6.9. Binary Functions","6.6. Bitwise Functions","6.16. Color Functions","6.2. Comparison Functions and Operators","6.3. Conditional Expressions","6.4. Conversion Functions","6.10. Date and Time Functions and Operators","6.7. Decimal Functions and Operators","6.12. JSON Functions","6.1. Logical Operators","6.18. Map Functions and Operators","6.5. Mathematical Functions and Operators","6.11. Regular Expression Functions","6.8. String Functions and Operators","6.19. Teradata Functions","6.13. URL Functions","6.15. Window Functions","Presto Documentation","2. Installation","2.5. Benchmark Driver","2.2. Command Line Interface","2.1. Deploying Presto","2.3. JDBC Driver","2.6. Web Connector for Tableau","2.4. Presto Verifier","7. SQL Language","7.1. Data Types","9. Migration","9.1. Migrating From Hive","1. Overview","1.1. Use Cases","11. Release Notes","11.68. Release 0.100","11.67. Release 0.101","11.66. Release 0.102","11.65. Release 0.103","11.64. Release 0.104","11.63. Release 0.105","11.62. Release 0.106","11.61. Release 0.107","11.60. Release 0.108","11.59. Release 0.109","11.58. Release 0.110","11.57. Release 0.111","11.56. Release 0.112","11.55. Release 0.113","11.54. Release 0.114","11.53. Release 0.115","11.52. Release 0.116","11.51. Release 0.117","11.50. Release 0.118","11.49. Release 0.119","11.48. Release 0.120","11.47. Release 0.121","11.46. Release 0.122","11.45. Release 0.123","11.44. Release 0.124","11.43. Release 0.125","11.42. Release 0.126","11.41. Release 0.127","11.40. Release 0.128","11.39. Release 0.129","11.38. Release 0.130","11.37. Release 0.131","11.36. Release 0.132","11.35. Release 0.133","11.34. Release 0.134","11.33. Release 0.135","11.32. Release 0.136","11.31. Release 0.137","11.30. Release 0.138","11.29. Release 0.139","11.28. Release 0.140","11.27. Release 0.141","11.26. Release 0.142","11.25. Release 0.143","11.24. Release 0.144","11.23. Release 0.144.1","11.22. Release 0.144.2","11.21. Release 0.144.3","11.20. Release 0.144.4","11.19. Release 0.144.5","11.18. Release 0.144.6","11.17. Release 0.144.7","11.16. Release 0.145","11.15. Release 0.146","11.14. Release 0.147","11.13. Release 0.148","11.12. Release 0.149","11.11. Release 0.150","11.10. Release 0.151","11.9. Release 0.152","11.8. Release 0.152.1","11.7. Release 0.152.2","11.6. Release 0.152.3","11.5. Release 0.153","11.4. Release 0.154","11.3. Release 0.155","11.2. Release 0.156","11.1. Release 0.157","11.114. Release 0.54","11.113. Release 0.55","11.112. Release 0.56","11.111. Release 0.57","11.110. Release 0.58","11.109. Release 0.59","11.108. Release 0.60","11.107. Release 0.61","11.106. Release 0.62","11.105. Release 0.63","11.104. Release 0.64","11.103. Release 0.65","11.102. Release 0.66","11.101. Release 0.67","11.100. Release 0.68","11.99. Release 0.69","11.98. Release 0.70","11.97. Release 0.71","11.96. Release 0.72","11.95. Release 0.73","11.94. Release 0.74","11.93. Release 0.75","11.92. Release 0.76","11.91. Release 0.77","11.90. Release 0.78","11.89. Release 0.79","11.88. Release 0.80","11.87. Release 0.81","11.86. Release 0.82","11.85. Release 0.83","11.84. Release 0.84","11.83. Release 0.85","11.82. Release 0.86","11.81. Release 0.87","11.80. Release 0.88","11.79. Release 0.89","11.78. Release 0.90","11.77. Release 0.91","11.76. Release 0.92","11.75. Release 0.93","11.74. Release 0.94","11.73. Release 0.95","11.72. Release 0.96","11.71. Release 0.97","11.70. Release 0.98","11.69. Release 0.99","3. Security","3.2. CLI Kerberos Authentication","3.1. Coordinator Kerberos Authentication","8. SQL Statement Syntax","8.1. ALTER SCHEMA","8.2. ALTER TABLE","8.3. CALL","8.4. COMMIT","8.5. CREATE SCHEMA","8.6. CREATE TABLE","8.7. CREATE TABLE AS","8.8. CREATE VIEW","8.9. DELETE","8.10. DESCRIBE","8.11. DROP SCHEMA","8.12. DROP TABLE","8.13. DROP VIEW","8.14. EXPLAIN","8.15. EXPLAIN ANALYZE","8.16. GRANT","8.17. INSERT","8.18. RESET SESSION","8.19. REVOKE","8.20. ROLLBACK","8.21. SELECT","8.22. SET SESSION","8.23. SHOW CATALOGS","8.24. SHOW COLUMNS","8.25. SHOW CREATE TABLE","8.26. SHOW CREATE VIEW","8.27. SHOW FUNCTIONS","8.28. SHOW PARTITIONS","8.29. SHOW SCHEMAS","8.30. SHOW SESSION","8.31. SHOW TABLES","8.32. START TRANSACTION","8.33. USE","8.34. VALUES"],titleterms:{"_default":12,"boolean":58,"case":[36,62],"char":58,"default":[12,18],"float":43,"function":[25,29,30,31,32,33,34,35,37,38,39,40,42,43,44,45,46,47,48,66,119,127,133,138,147,148,153,168,208],"new":[102,158],"null":[35,41],"try":36,about:10,access:[9,10,27,60,180],accumulo:6,add:[13,139],addit:[10,179,180],administr:0,aggreg:[25,30,48,133,135],aliv:15,all:[13,35],also:[182,183,185,186,187,188,189,192,193,194,195,196,197,198,199,200,201,203,206,207,211,213,215],alter:[182,183],amazon:[9,135,139],analyz:196,ani:35,anoth:25,ansi:60,apach:13,approxim:30,argument:51,arithmet:39,arrai:[31,58,60,156,176],authent:[9,10,179,180],author:[10,82],avoid:60,awar:93,base:10,basic:13,batch:15,benchmark:51,between:[35,80],big:[73,158],bigint:58,binari:[32,39,133,147],bitwis:33,black:[7,117],blackhol:127,bound:60,bucket:133,buffer:12,bug:[138,144],build:26,bytecod:152,call:184,cassandra:[8,72,83,117,119,139,144,151,154,158],cast:[60,80],catalog:[19,53,138,204],chang:[64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,138,144,145,147,148,151,152,153,154,155,156,157,158,159,161,164,165,166,167,168,169,170,171,172,173,174,175,176,177],claus:202,cli:[51,83,93,96,116,127,133,179],client:10,cluster:[8,9,12,15,67,77,80],coalesc:36,code:[24,26],collect:15,color:34,column:[6,12,13,18,202,205],command:52,commit:185,comparison:[35,39],compil:152,complex:60,compound:138,concaten:[31,60],concern:15,concurr:103,condit:36,config:[3,53,180],configur:[1,2,6,7,8,9,10,11,12,14,15,16,17,18,19,20,23,27,53,147,179,180],connect:[12,15],connector:[5,6,7,8,9,11,12,13,14,15,16,17,18,19,20,22,24,55,64,119,138,147,148,154,156],connectorfactori:[22,24],connectormetadata:22,connectorrecordsetprovid:22,connectorsplitmang:22,constructor:139,control:[27,180],conveni:38,convers:[37,38],convert:6,coordin:[147,180],count:18,cpu:133,creat:[13,186,187,188,189,206,207],creation:134,credenti:[9,15],cross:[134,202],cryptographi:[179,180],csv:12,cursor:15,custom:[9,26],dai:58,data:[6,9,13,58],databas:[17,18],datasourc:147,date:[12,38,46,58,144,167],debug:[179,180],decim:[39,58],decod:12,decript:13,definit:[12,15,18],delet:190,delimit:18,depend:6,deploi:[26,53],describ:191,descript:[12,18,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215],develop:21,differ:60,dir:[12,18],distinct:[35,133,135,138],distribut:[133,155],divid:60,document:49,doubl:58,driver:[51,54,93,123,127],drop:[192,193,194],dual:148,dynam:[60,103],effect:41,effici:133,enabl:10,encod:47,encrypt:9,end:10,environ:[179,180],epilogu:13,event:23,evolut:9,exampl:[7,9,10,24,25,36,182,183,184,185,186,187,188,189,190,192,193,194,195,196,197,198,199,200,201,203,206,209,213,214,215],exampleconnector:24,examplemetadata:24,examplerecordsetprovid:24,examplesplitmanag:24,except:202,execut:179,exist:202,expand:60,explain:[195,196],express:[36,44,60,66],extens:[179,180],extern:6,extract:[38,47],featur:[6,119,127,168],feed:13,field:12,file:[9,10,12,13,14,18,123,179,180],filter:138,fix:[119,133,138,144],format:152,from:[6,13,35,60,133],gain:133,gener:[30,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,126,127,128,129,130,131,144,147,148,151,152,153,154,155,156,157,158,159,161,164,165,166,167,168,169,170,171,172,173,174,175,176,177],global:2,grace:92,grant:197,greatest:35,group:[2,127,202],guid:21,hadoop:[9,10,135],hash:133,have:202,hdf:[9,10],hide:[12,18],hive:[9,10,60,65,66,67,68,76,77,78,79,83,87,88,90,93,96,98,101,102,103,104,106,107,108,109,111,116,117,118,119,120,121,123,125,127,128,129,130,131,133,144,148,152,153,154,155,156,157,158,159,168,174,175,176],hole:[7,117],host:15,http:24,http_request_log:14,identifi:60,imperson:10,implement:[23,24,25,27],improv:[80,138,148],index:[6,18,60,155],inform:[10,179,180],insert:198,instal:[6,13,50,53],instead:60,integ:[58,60],interfac:[4,52],intern:[6,12,18],intersect:202,interv:[38,58,119],introduct:13,iter:6,java:[38,179,180],jdbc:[54,93,123,127,138],jmx:[11,119,127],join:[60,134,155,202],json:[12,40,58,80,153],json_array_get:133,jvm:[3,53],kafka:[12,13,118,119,154,155],keep:15,kei:[12,18],kerbero:[9,10,179,180],keystor:[179,180],keytab:[10,179,180],keyword:133,known:13,languag:[57,119,127,168],learn:[147,148],least:35,length:147,level:53,limit:[9,16,17,138,190,197,200,202],line:52,listen:23,liter:39,live:13,load:[6,13],local:[14,123,144],log:53,logic:41,machin:[147,148],make:13,manag:[6,24,67,77,80],map:[13,30,42,58,60,156,176],mathemat:43,maven:26,max:15,memori:[80,171,172],messag:[12,13],metadata:[6,19,24,26,158],metastor:10,migrat:[59,60],min:15,miscellan:[37,135,139],mit:[179,180],mongodb:15,month:58,multipl:[8,9,12,15,16,17,18],mysql:[16,38,83,92,118,119,123,127,154],name:[12,18,202],network:93,node:[12,18,19,53,180],non:133,none:10,note:63,nullif:36,number:[12,60,153],objectid:15,onli:158,onto:13,oper:[29,31,35,38,39,41,42,43,45,60],optim:[138,144,153,158],option:133,orc:[158,171,172],order:202,other:119,out:60,outer:60,output:51,overview:[6,9,12,26,61],parallel:67,parametr:[25,155],parquet:102,partit:209,password:18,per:15,pluggabl:127,plugin:[24,25,26,151,180],point:43,polici:[179,180],postgresql:[17,83,118,119,123,127,154],predic:[35,133,138],prefer:15,prefix:18,presto:[3,10,13,49,53,56,62,148,179,180],prevent:147,princip:[10,179,180],procedur:19,properti:[2,3,6,8,9,10,12,14,15,18,53,77,87,156,180],protect:9,provid:[9,24],pushdown:133,qualifi:202,quantifi:35,queri:[8,11,13,16,17,19,51,60,73,158],queue:1,quot:60,rang:[35,133,138],rank:48,raptor:[147,161],raw:12,read:15,reader:[102,158],real:58,record:24,redi:[18,118,130],regular:[44,66],releas:[63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177],remov:73,replica:15,requir:15,reserv:133,reset:199,resourc:[2,67,77,127,180],revok:200,rollback:201,row:[12,58,153,176],rule:10,run:53,runtim:19,scalar:[25,202],scan:18,schedul:[93,147,153],schema:[9,10,12,14,15,18,20,133,138,182,186,192,210],schema_properti:19,second:58,secur:[10,178],see:[182,183,185,186,187,188,189,192,193,194,195,196,197,198,199,200,201,203,206,207,211,213,215],seed:15,select:202,selector:2,serial:6,server:[16,17,18],servic:[10,179,180],session:[6,10,77,156,199,203,211],set:[3,15,24,203],setup:13,show:[133,204,205,206,207,208,209,210,211,212],shutdown:92,simpl:133,size:[12,15],smallint:58,socket:15,some:35,sourc:133,spi:[26,65,69,77,83,98,104,122,123,127,129,130,138,144,145,153,168,176],split:[24,103],sql:[57,60,181],stamp:13,standard:60,start:[60,213],statement:181,statist:30,step:13,storag:152,stream:155,string:[45,46,60],subqueri:202,subscript:[31,42,60],suit:51,support:[9,10,66,73,139,158],synopsi:[182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215],syntax:[60,181],system:[19,27,64,144,180],tabl:[6,8,10,12,13,14,15,18,19,87,133,134,139,148,183,187,188,193,206,212],table_properti:19,tableau:55,tablesampl:202,target:60,task:[19,67],teradata:46,text:12,thrift:10,time:[12,13,15,38,58,144],timeout:[12,15],timestamp:58,tinyint:58,topic:13,topolog:93,tpch:[20,138],transact:[19,213],trigonometr:43,troubleshoot:[179,180],truncat:38,tune:[3,9],tutori:13,tweet:13,twitter:13,type:[9,10,28,58,60,144,147,155,156,167,176],udf:60,unari:39,unicod:[45,66],union:202,unnest:[60,202],unsupport:6,url:47,usag:[6,171,172],user:10,usernam:9,valu:[13,48,139,215],varbinari:58,varchar:[58,80],variabl:[6,147],verif:180,verifi:[56,83,88,116,119,122,123,148,171],via:26,view:[148,189,194,207],wait:15,web:[4,55,65,127],what:62,when:60,who:62,window:[48,138],work:147,write:15,year:58,zone:[38,58,144]}})