searchindex.js

Search.setIndex({envversion:49,filenames:["admin","admin/properties","admin/resource-groups","admin/spill","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/memory","connector/mongodb","connector/mysql","connector/postgresql","connector/redis","connector/redshift","connector/sqlserver","connector/system","connector/thrift","connector/tpcds","connector/tpch","develop","develop/connectors","develop/event-listener","develop/example-http","develop/functions","develop/password-authenticator","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/geospatial","functions/json","functions/lambda","functions/logical","functions/map","functions/math","functions/regexp","functions/session","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/reserved","language/types","migration","migration/from-hive","overview","overview/concepts","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.157.1","release/release-0.158","release/release-0.159","release/release-0.160","release/release-0.161","release/release-0.162","release/release-0.163","release/release-0.164","release/release-0.165","release/release-0.166","release/release-0.167","release/release-0.168","release/release-0.169","release/release-0.170","release/release-0.171","release/release-0.172","release/release-0.173","release/release-0.174","release/release-0.175","release/release-0.176","release/release-0.177","release/release-0.178","release/release-0.179","release/release-0.180","release/release-0.181","release/release-0.182","release/release-0.183","release/release-0.184","release/release-0.185","release/release-0.186","release/release-0.187","release/release-0.188","release/release-0.189","release/release-0.190","release/release-0.191","release/release-0.192","release/release-0.193","release/release-0.194","release/release-0.195","release/release-0.196","release/release-0.197","release/release-0.198","release/release-0.199","release/release-0.200","release/release-0.201","release/release-0.202","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/built-in-system-access-control","security/cli","security/internal-communication","security/ldap","security/server","security/tls","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/deallocate-prepare","sql/delete","sql/describe","sql/describe-input","sql/describe-output","sql/drop-schema","sql/drop-table","sql/drop-view","sql/execute","sql/explain","sql/explain-analyze","sql/grant","sql/insert","sql/prepare","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-grants","sql/show-schemas","sql/show-session","sql/show-tables","sql/start-transaction","sql/use","sql/values"],objects:{"":{"typeof":[44,0,1,""],ST_Area:[47,0,1,""],ST_AsText:[47,0,1,""],ST_Boundary:[47,0,1,""],ST_Buffer:[47,0,1,""],ST_Centroid:[47,0,1,""],ST_Contains:[47,0,1,""],ST_ConvexHull:[47,0,1,""],ST_CoordDim:[47,0,1,""],ST_Crosses:[47,0,1,""],ST_Difference:[47,0,1,""],ST_Dimension:[47,0,1,""],ST_Disjoint:[47,0,1,""],ST_Distance:[47,0,1,""],ST_EndPoint:[47,0,1,""],ST_Envelope:[47,0,1,""],ST_Equals:[47,0,1,""],ST_ExteriorRing:[47,0,1,""],ST_GeometryFromText:[47,0,1,""],ST_GeometryN:[47,0,1,""],ST_GeometryType:[47,0,1,""],ST_Intersection:[47,0,1,""],ST_Intersects:[47,0,1,""],ST_IsClosed:[47,0,1,""],ST_IsEmpty:[47,0,1,""],ST_IsRing:[47,0,1,""],ST_IsSimple:[47,0,1,""],ST_IsValid:[47,0,1,""],ST_Length:[47,0,1,""],ST_LineFromText:[47,0,1,""],ST_NumGeometries:[47,0,1,""],ST_NumInteriorRing:[47,0,1,""],ST_NumPoints:[47,0,1,""],ST_Overlaps:[47,0,1,""],ST_Point:[47,0,1,""],ST_Polygon:[47,0,1,""],ST_Relate:[47,0,1,""],ST_StartPoint:[47,0,1,""],ST_SymDifference:[47,0,1,""],ST_Touches:[47,0,1,""],ST_Within:[47,0,1,""],ST_X:[47,0,1,""],ST_XMax:[47,0,1,""],ST_XMin:[47,0,1,""],ST_Y:[47,0,1,""],ST_YMax:[47,0,1,""],ST_YMin:[47,0,1,""],abs:[52,0,1,""],acos:[52,0,1,""],approx_distinct:[37,0,1,""],approx_percentile:[37,0,1,""],arbitrary:[37,0,1,""],array_agg:[37,0,1,""],array_distinct:[38,0,1,""],array_except:[38,0,1,""],array_intersect:[38,0,1,""],array_join:[38,0,1,""],array_max:[38,0,1,""],array_min:[38,0,1,""],array_position:[38,0,1,""],array_remove:[38,0,1,""],array_sort:[38,0,1,""],array_union:[38,0,1,""],arrays_overlap:[38,0,1,""],asin:[52,0,1,""],atan2:[52,0,1,""],atan:[52,0,1,""],avg:[37,0,1,""],bar:[41,0,1,""],bing_tile:[47,0,1,""],bing_tile_at:[47,0,1,""],bing_tile_coordinates:[47,0,1,""],bing_tile_polygon:[47,0,1,""],bing_tile_quadkey:[47,0,1,""],bing_tile_zoom_level:[47,0,1,""],bing_tiles_around:[47,0,1,""],bit_count:[40,0,1,""],bitwise_and:[40,0,1,""],bitwise_and_agg:[37,0,1,""],bitwise_not:[40,0,1,""],bitwise_or:[40,0,1,""],bitwise_or_agg:[37,0,1,""],bitwise_xor:[40,0,1,""],bool_and:[37,0,1,""],bool_or:[37,0,1,""],cardinality:[38,0,1,""],cast:[44,0,1,""],cbrt:[52,0,1,""],ceil:[52,0,1,""],ceiling:[52,0,1,""],char2hexint:[56,0,1,""],checksum:[37,0,1,""],chr:[55,0,1,""],codepoint:[55,0,1,""],color:[41,0,1,""],concat:[55,0,1,""],contains:[38,0,1,""],corr:[37,0,1,""],cos:[52,0,1,""],cosh:[52,0,1,""],cosine_similarity:[52,0,1,""],count:[37,0,1,""],count_if:[37,0,1,""],covar_pop:[37,0,1,""],covar_samp:[37,0,1,""],crc32:[39,0,1,""],cume_dist:[58,0,1,""],current_timezone:[45,0,1,""],date:[45,0,1,""],date_add:[45,0,1,""],date_diff:[45,0,1,""],date_format:[45,0,1,""],date_parse:[45,0,1,""],date_trunc:[45,0,1,""],day:[45,0,1,""],day_of_month:[45,0,1,""],day_of_week:[45,0,1,""],day_of_year:[45,0,1,""],degrees:[52,0,1,""],dense_rank:[58,0,1,""],dow:[45,0,1,""],doy:[45,0,1,""],e:[52,0,1,""],element_at:[38,0,1,""],every:[37,0,1,""],exp:[52,0,1,""],extract:[45,0,1,""],filter:[38,0,1,""],first_value:[58,0,1,""],flatten:[38,0,1,""],floor:[52,0,1,""],format_datetime:[45,0,1,""],from_base64:[39,0,1,""],from_base64url:[39,0,1,""],from_base:[52,0,1,""],from_big_endian_64:[39,0,1,""],from_hex:[39,0,1,""],from_ieee754_32:[39,0,1,""],from_ieee754_64:[39,0,1,""],from_iso8601_date:[45,0,1,""],from_iso8601_timestamp:[45,0,1,""],from_unixtime:[45,0,1,""],from_utf8:[55,0,1,""],geometric_mean:[37,0,1,""],geometry_invalid_reason:[47,0,1,""],geometry_to_bing_tiles:[47,0,1,""],great_circle_distance:[47,0,1,""],greatest:[42,0,1,""],hamming_distance:[55,0,1,""],histogram:[37,0,1,""],hmac_md5:[39,0,1,""],hmac_sha1:[39,0,1,""],hmac_sha256:[39,0,1,""],hmac_sha512:[39,0,1,""],hour:[45,0,1,""],index:[56,0,1,""],infinity:[52,0,1,""],inverse_normal_cdf:[52,0,1,""],is_finite:[52,0,1,""],is_infinite:[52,0,1,""],is_json_scalar:[48,0,1,""],is_nan:[52,0,1,""],json_array_contains:[48,0,1,""],json_array_get:[48,0,1,""],json_array_length:[48,0,1,""],json_extract:[48,0,1,""],json_extract_scalar:[48,0,1,""],json_format:[48,0,1,""],json_parse:[48,0,1,""],json_size:[48,0,1,""],kurtosis:[37,0,1,""],lag:[58,0,1,""],last_value:[58,0,1,""],lead:[58,0,1,""],least:[42,0,1,""],length:[55,0,1,""],levenshtein_distance:[55,0,1,""],line_locate_point:[47,0,1,""],ln:[52,0,1,""],log10:[52,0,1,""],log2:[52,0,1,""],lower:[55,0,1,""],lpad:[55,0,1,""],ltrim:[55,0,1,""],map:[51,0,1,""],map_agg:[37,0,1,""],map_concat:[51,0,1,""],map_entries:[51,0,1,""],map_filter:[51,0,1,""],map_from_entries:[51,0,1,""],map_keys:[51,0,1,""],map_union:[37,0,1,""],map_values:[51,0,1,""],map_zip_with:[51,0,1,""],max:[37,0,1,""],max_by:[37,0,1,""],md5:[39,0,1,""],min:[37,0,1,""],min_by:[37,0,1,""],minute:[45,0,1,""],mod:[52,0,1,""],month:[45,0,1,""],multimap_agg:[37,0,1,""],multimap_from_entries:[51,0,1,""],nan:[52,0,1,""],normal_cdf:[52,0,1,""],normalize:[55,0,1,""],now:[45,0,1,""],nth_value:[58,0,1,""],ntile:[58,0,1,""],numeric_histogram:[37,0,1,""],parse_datetime:[45,0,1,""],parse_duration:[45,0,1,""],percent_rank:[58,0,1,""],pi:[52,0,1,""],position:[55,0,1,""],pow:[52,0,1,""],power:[52,0,1,""],quarter:[45,0,1,""],radians:[52,0,1,""],rand:[52,0,1,""],random:[52,0,1,""],rank:[58,0,1,""],reduce:[38,0,1,""],regexp_extract:[53,0,1,""],regexp_extract_all:[53,0,1,""],regexp_like:[53,0,1,""],regexp_replace:[53,0,1,""],regexp_split:[53,0,1,""],regr_intercept:[37,0,1,""],regr_slope:[37,0,1,""],render:[41,0,1,""],repeat:[38,0,1,""],replace:[55,0,1,""],reverse:[55,0,1,""],rgb:[41,0,1,""],round:[52,0,1,""],row_number:[58,0,1,""],rpad:[55,0,1,""],rtrim:[55,0,1,""],second:[45,0,1,""],sequence:[38,0,1,""],sha1:[39,0,1,""],sha256:[39,0,1,""],sha512:[39,0,1,""],shuffle:[38,0,1,""],sign:[52,0,1,""],simplify_geometry:[47,0,1,""],sin:[52,0,1,""],skewness:[37,0,1,""],slice:[38,0,1,""],split:[55,0,1,""],split_part:[55,0,1,""],split_to_map:[55,0,1,""],sqrt:[52,0,1,""],stddev:[37,0,1,""],stddev_pop:[37,0,1,""],stddev_samp:[37,0,1,""],strpos:[55,0,1,""],substr:[55,0,1,""],substring:[56,0,1,""],sum:[37,0,1,""],tan:[52,0,1,""],tanh:[52,0,1,""],timezone_hour:[45,0,1,""],timezone_minute:[45,0,1,""],to_base64:[39,0,1,""],to_base64url:[39,0,1,""],to_base:[52,0,1,""],to_big_endian_64:[39,0,1,""],to_char:[56,0,1,""],to_date:[56,0,1,""],to_hex:[39,0,1,""],to_ieee754_32:[39,0,1,""],to_ieee754_64:[39,0,1,""],to_iso8601:[45,0,1,""],to_milliseconds:[45,0,1,""],to_timestamp:[56,0,1,""],to_unixtime:[45,0,1,""],to_utf8:[55,0,1,""],transform:[38,0,1,""],transform_keys:[51,0,1,""],transform_values:[51,0,1,""],trim:[55,0,1,""],truncate:[52,0,1,""],try_cast:[44,0,1,""],upper:[55,0,1,""],url_decode:[57,0,1,""],url_encode:[57,0,1,""],url_extract_fragment:[57,0,1,""],url_extract_host:[57,0,1,""],url_extract_parameter:[57,0,1,""],url_extract_path:[57,0,1,""],url_extract_port:[57,0,1,""],url_extract_protocol:[57,0,1,""],url_extract_query:[57,0,1,""],var_pop:[37,0,1,""],var_samp:[37,0,1,""],variance:[37,0,1,""],week:[45,0,1,""],week_of_year:[45,0,1,""],width_bucket:[52,0,1,""],wilson_interval_lower:[52,0,1,""],wilson_interval_upper:[52,0,1,""],word_stem:[55,0,1,""],xxhash64:[39,0,1,""],year:[45,0,1,""],year_of_week:[45,0,1,""],yow:[45,0,1,""],zip:[38,0,1,""],zip_with:[38,0,1,""]},runtime:{kill_query:[23,0,1,""]}},objnames:{"0":["py","function","Python function"]},objtypes:{"0":"py:function"},terms:{"01t00":24,"0b8e":12,"0prrybcp1ygj8xcbpmwhl5":14,"0th":45,"0x00ff00":41,"0xff0000":41,"0xffff00":41,"10ffff":83,"10m":7,"11kb":262,"128mb":16,"14m":53,"16be":56,"16mb":[1,24],"1b8af1a7451a":12,"1gb":[2,63],"1mb":[1,153],"1st":45,"20151207_215727_00146_tx3nr":23,"2017b":166,"20mb":1,"24kb":262,"25m":212,"28t17":14,"2gb":184,"2mb":1,"2nd":45,"32kb":262,"32m":63,"32mb":1,"3ca":53,"3cb":53,"3rd":45,"44kb":262,"4mb":17,"500kb":189,"500m":9,"50gb":63,"55b151633864d6438c61a9c":17,"57m":262,"5gb":63,"62mb":262,"64bit":35,"64kb":13,"6lreav6kr6plvcgl2arl":14,"7day_act":71,"8byte":35,"8mb":230,"8u92":154,"9th":202,"abstract":[7,77,192],"boolean":[1,9,11,13,14,17,20,24,31,37,38,41,43,47,48,50,51,52,53,65],"break":[73,135,148,202],"byte":[7,13,14,20,23,24,31,39,57,105,106,118,130,161,202,204,211,222,256,262],"case":[1,3,8,10,11,13,17,30,31,37,38],"catch":[2,196],"char":22,"class":[7,9,10,30,31,33,53,63,64,110,126,131,135,139,154,156,175,179,184,192,196,205,214],"default":[1,2,3,4,7,8,9,10,11,12],"delete":[2,7,10,11,18,19,21,22,59,68,83,99,102,119,131,162,237,243],"double":[9,13,14,31,38,42,48],"else":[38,43,68],"enum":24,"export":[2,63],"false":[37,42,50,68,118],"final":[14,18,19,21,22,31,38,65,73,79,139,149,171,176,202,205,261,262,269],"float":[9,13,22,39,47],"import":[1,28,48,178,196,202,240,242],"int":[9,13,22,24,38,41,65,66,69,113,162],"long":[11,13,14,23,24,28,31,35,80,120,144,145,150,151,161,168,179,180,182,186,196,198,212],"new":[1,2,7,8,10,13,17,20,23,30,31,33,35,38,43,53,64,65,77,78,79,85,89,92,95,99,102,104],"null":[7,8,10,20,24,31,37,38],"public":[30,31,196,239,263,267],"return":[1,3,8,12,13,16,17,24,28,29,30,31,32,34,35,37,38,39,40,41,42,43,44,45,47,48,51,52,53,54,55,56,57,58,73,78,89,95,98,99,101,105,112,113,116,117,126,131,132,135,139,140,145,148,149,150,155,156,167,169,170,179,181,183,184,186,189,190,196,202,210,212,214,225,237,239,242,269,282],"short":[7,13,41,154,155,167,168,179],"static":31,"super":46,"switch":[1,188,213,239],"throw":[13,16,24,105,226],"true":[1,2,7,9,10,11,13,20,31,37,38,41,42,43,47,48,50,51,53,61,63,64,68,69,74,77,100,105,113,114,115,120,147,166,168,173,183,192,206,211,216,219,226,237,238,239,240,241,256,261,270],"try":1,"typeof":[44,139],"var":[63,205],"void":[31,196],"while":[3,7,10,63,64,66,73,91,100,169,176,178,182,183,184,196,226,232,239,269],__hive_default_partition__:[214,216],__internal_partitions__:180,_col0:[14,197,269],_col1:[197,256,261],_col2:269,_col3:269,_col4:269,_host:11,_id:17,_kei:[13,14,20],_key_corrupt:[13,14,20],_key_length:[13,14,20],_messag:[13,14],_message_corrupt:[13,14],_message_length:[13,14],_orc_:61,_partition_id:[13,14],_partition_offset:[13,14],_schema:17,_segment_count:[13,14],_segment_end:[13,14],_segment_start:[13,14],_valu:20,_value_corrupt:20,_value_length:20,aaa:43,abandon:[175,202,205],abbreviat:45,abc0:38,abc:[38,48,173],abcd:38,abil:[7,12,77,102,109,149,165,178,188],abl:[1,10,13,179,202,238,239,241],abnorm:262,abort:[95,128,139,173,180,181],abortedexcept:213,about:[5,7,9,10],abov:[1,2,8,9,13,18,19,20,21,22,31,42,45,61,63,64,83,99,148,178,202,205,241,269],above:24,absent:13,absolut:[2,10,52,168],accept:[2,5,13,24,31,41,63,91,100,179,224],access:[5,6],accesstoken:64,accident:182,accomplish:10,accor:14,accord:[2,13,14,39,41,52,58,187],accordingli:12,accou:14,account:[1,11,14,82,84,103,105,108,110,123,128,141,156,162,165,167,184,191,202,209,269],account_bal:14,accountbal:14,acctbal:269,accumul:31,accumulatorst:31,accumulatorstatefactori:31,accumulatorstatemetadata:31,accumulatorstateseri:31,accumulo:6,accumulo_home:7,accumulorowseri:7,accumulot:7,accur:[47,105,150,262],accuraci:[37,102,105,108],achiev:241,acknowledg:[9,183],acknowledged:17,acl:11,aco:52,across:[1,24,34,58,63,73,164,180,191,196,211,239],act:[62,73],activ:[1,29,73,94,139,154,169,182,185,198],activecount:1,actual:[11,14,30,43,63,118,120,170,181,191,212,240],adapt:[28,73,155,238,241],add:[2,7,9,10,11,13],added:[82,83,202,211,219,224,226],addit:[1,7,9,10,11,12,13,14,17,18,20,24,31,33,38,61,63,77,98,147,165,168,172,175,191,193,202,226,230,238,240,241,249,262,264,269],addition:[2,3,5,7,9],addprinc:[238,241],address:[3,9,14],adhoc:2,adhoc_:2,adjust:[1,17,115,128,150,155],admin:[2,11,237,238,241],admin_serv:[238,241],advanc:[9,194,202,206],advantag:[1,73,88,161,162,167,177,189,204],advertis:[73,155],aes:10,affect:[10,181,187,215],africa:269,after:[1,7,10,11,16,24,29,32,34,52,58,63,65,71,85,91,92,95,108,132,140,145,154,163,165,167,171,173,175,179,183,202,212,216,227,238,241,269],afterward:3,again:7,against:[2,7,9,11,13,14,28,48,65,66,73,167,187,206,211,216,226,237,240],agent:139,agg:134,aggregation_operator_unspill_memory_limit:170,aggregationfunct:[31,135],ainst:14,air:253,airlift:[14,24],aka:24,akiaiosfodnn7example:193,alan:7,algeria:269,algorithm:[1,25,26,37,47,180,191,210,239],alia:[25,26,37,45,52,56,91,139,154,162,226,239,240,242,254,256,269],alias:[130,169,256,282],alic:[237,263,267],align:[104,179,186,191],all:[1,2,3,5,7,9,10,11,12,13],alloc:[3,13,79,89,168,178,181,184,188,213,218,220,222,229,230,234],allornonevalueset:24,allow:[1,2,3,8,9,10,11,12,13,14,15,17,18,19,20,21,22,24,28,30,33,34,35,63,73,78,80,84,89,95,100,102,113,129,131,134,135,139,145,149,154,155,156,158,162,163,164,167,170,172,173,176,177,178,179,180,181,184,185,186,187,188,189,190,193,196,197,205,206,211,212,213,214,216,224,226],allview:135,alon:14,along:[3,5,9,23,68,73,92,126,131,255,262,272],alongsid:73,alphabet:39,alphanumer:[57,211],alreadi:[1,7,10,120,155,168,177,211,238,241,248,249,250,251],alreadyexistsexcept:153,also:[1,2,7,8,9,10,12,14,25,26,29,30,31,32,34,35,40,42,48,51,63,64,69,73,74,77,79,100,101,102,105,115,125,131,164,178,190,191,192,202,205,209,237,238,239,240,241],alter:[1,2,7,11,18,19,21,22,34,59,68,95,100,139,168,187,211,229,243],altern:[31,63,74,197,206],although:[13,17,114,191,212,216],alwai:[1,8,13,20,53,55,69,73,77,85,88,89,92,105,131,141,161,164,171,181,184,185,196,212],amazonaw:[10,190],amazons3cli:10,ambigu:[133,269],america:[45,69,131,185,202,240,269],among:[2,14],amount:[1,2,3,30,63,74,79,89,100,161,170,177,178,239,241],analog:58,analysi:[29,65,74,77,108,154,185,192,219,269],analyt:74,analyz:[5,23,108,189,196,210],analyze:[59,120,145,150,152,168,170,243,261],ancestor:2,anchor:53,angele:202,angl:52,ani:[2,3,7,8,10,13,14,16,17,26,31,34,37,38,42,45,47,48,57,58,63,65,69,73,79,89,100,108,132,139,155,167,176,180,191,193,196,202,204,211,212,219,237,239,240,251,269,276],anim:[197,269],annot:[31,33,135],announc:89,anomal:47,anomali:262,anonym:[186,189,282],anoth:[9,10,13,17,18,19,20,21,22,24,66,73,108,154,189,251],another_group:240,another_orderd:249,another_orderkei:249,ansi:41,answer:[9,193],any:[7,9,10,13],anymor:196,anyth:63,anywher:[197,282],apac:99,apach:[7,10,13],api:[7,10,14,28,65,73,77,89,95,110,113,126,131,132,141,155,191,194,197,211],app:30,appear:[13,95,105,108,166,172,196,202,241,255,269],appendcolumn:185,appendnul:31,appendstructur:186,appl:[197,246],appli:[1,2,9,10,38,47,51,73,84,102,119,126,131,139,211,222,238,269],applic:[3,64],applicationnam:2,apply:180,approach:3,appropri:[7,10,13,17,18,19,20,21,22,24,177,240],approx_avg:211,approx_distinct:[1,37,113,177,193,198,224,226],approx_percentil:[37,100,102,113,153,169],arbitrari:[13,20,37,89,95,134,161,176,211,224,269],arc:52,architectur:73,archiv:[238,241],area:47,argentina:269,argument:[10,11,31,38,41,42,43,45,46,47,52],argumenttyp:31,arithmet:[37,38],ariti:213,around:[31,170],arrai:[7,13,17,24,36,37],array1:38,array2:38,array:[10,38,48,51,52],array_agg:[37,77,108,131,132,134,185],array_distinct:[38,76,80,116,139],array_el:91,array_except:[38,155],array_intersect:[38,77,130,161],array_join:[38,78,151,183],array_max:[38,85,177],array_min:[38,85,177],array_posit:[38,77],array_remov:[38,79],array_sort:[38,131,139,161,186,216],array_union:[38,135],arrayblock:[170,171,185],arrayn:38,arrays_overlap:[38,155,161],arriv:[13,14],artifact:196,artifactid:[33,64],asc:[172,269],ascend:[37,52],ascii:[9,57,172,212,233],asia:[82,240,269],asin:52,ask:[10,30,42,65,164,242],assembl:33,assert:78,assign:[10,211,219,238,241,267,269],associ:[2,7,10,11,37,51,73,77],assum:[10,13,14,22,24,31,45,47,52,55,78,226],assume:[3,24,46],async:14,asynchron:[142,212],asynchttpexecutionmbean:1,atan2:52,atan:52,atomic:139,attempt:[7,10,16,24,28,80,139,140,143,181,191,226],attribut:[1,13,14,179,222,240,272],auspic:74,auth:[7,176,240],authent:9,authenti:64,author:[7,9,10],authorizedgroup:240,auto:[7,77,131,175,202],auto_increment:66,autocommit:5,autocomplet:79,automat:[10,23,31,44,63,79,95,105,149,161,185,205,211],automaton:1,automobile:[14,269],avail:[1,3,5,6,7,9,10,12,13,14,15,17,18,19,20,21,22,23,24,30,33,62,63,64,65,69,73,76,95,99,131,157,165,191,202,205,214,238,241,246,248,249,250,271,275],averag:[1,31,37,38,164,178,262],averageaggreg:31,avg:[1,37,139,162,211,262,269],avg_doubl:31,avoid:[1,9,47,63],avro:[10,141,165],awai:[7,190],await:[5,196],awar:[1,9,53,99,177,220,226,239],aws:[10,118,139,185,193,197],awscredentialsprovid:10,azeri:55,azure:22,b09:12,back:[1,3,7,14,24,28,33,93,131,147,167,169,191,206,210,226],background:[89,157],backoff:[9,10,24,77,157,212],backquot:71,backslash:[53,155],backup:219,backward:[77,81,89,94,95,110,116,134,135,139,142,148,173,177,191,192,196,202,203,211,214,225,226,234],bad:[7,17,166],bahia_bandera:185,balanc:[1,131,211,269],banana:197,bandwidth:239,banned_us:11,bar:[7,41,69,164],base64:[39,211],base:[1,7,10],bash:[238,240],basi:[1,10,114,167,202,216],basic:[1,10],batch:[1,7,9],batchscann:7,batchsiz:17,batchwrit:7,bb14:12,bbb:43,bean:[12,14],bear:197,becaus:[1,7,11,14,24,33,48,63,65,73,164,202,205,213,269],becom:[1,2,3,17,80,100,239],been:[5,10,11,29,32,34,61,74,77,78,85,92,95,114,115,154,161,164,169,174,178,179,182,183,185,189,202,205,206,211,212,213,216,225,239,276],befor:[1,2,7,8,10,13,34,58,77,81,88,92,105,108,110,116,120,126,130,131,134,135,139,141,142,147,164,169,170,173,177,185,189,191,192,196,203,205,211,225,226,231,234,237,276],begin:[1,7,58,74],beginqueri:154,behalf:176,behav:8,behavior:[1,7,10,13,34,48,62,69,71,78,111,128,134,148,150,168,177,179,183,185,186,188,196,206,237,249,269],belong:[2,240],below:[1,2,7,11,13,20,24,31,35,41,46,48,63,69,180,202,237,239,240,241,262,269],ben:37,benchmark:[25,26,59,60],benefit:[188,216],berlin:202,berner:7,bernoulli:[52,269],besid:14,best:[7,63,69,149,192],beta:[13,211],better:[1,31,39,135,182,226],between:[1,7,9,13,18,19,20,21,22,24,30,31,37,41],big:[28,39],bigger_ord:249,biggest:42,bigint:[7,8,9,10,13,14,17,20,22,24,37,38,39,40,41,42,43,44,45,47,48,51,52,55,56,57,58,65],bigintarraydata:24,bigintdata:24,biginttyp:[31,35],billion:[73,128],bin:[14,52,63,238,240],binari:[24,35,36],binary1:39,binary2:39,binary:[24,205],binaryn:39,bind:[31,190,240,269],bing_til:47,bing_tile_at:[47,176],bing_tile_coordin:[47,187],bing_tile_polygon:[47,176,186],bing_tile_quadkei:47,bing_tile_zoom_level:47,bing_tiles_around:[47,189],bingtil:[47,177],bird:269,birthdai:7,bit:[7,12,31,39,40,69,100,178,225,269],bit_count:[40,113,178],bitwis:36,bitwise_and:[40,113],bitwise_and_agg:[37,40,143],bitwise_not:[40,113],bitwise_or:[40,113],bitwise_or_agg:[37,40,143],bitwise_xor:[40,113],black:6,blackhol:[8,102],blith:14,blithel:14,blk:53,blob:[9,24,95,206],block:[5,17,24,35,53,76,77,81,82,94,119,141,154,164,178,179,182,186,194,196,211,234,239,269],blockbuild:[31,186],blocked:[5,80],bloom:[139,187],bloomberg:7,blue:41,bob:[2,51,237],bob_ag:51,bodi:[49,104,151],bogu:116,bold:14,boldli:14,book:[48,211],bool:[24,65],bool_and:[37,226],bool_or:[37,226],booleandata:24,boost:14,bootstrap:[30,139],border:179,both:[1,2,7,9,10,12,13,16,31,38,42,47,48,50,63,64,73,74,84,92,99,154,161,178,186,191,196,202,205,206,211,213,237,263,267,269],bottleneck:[1,5,239],bottom:[179,237],bougainvil:82,bound1:52,bound2:52,bound:[1,24,37,47,52],boundari:[47,53],box:[47,179],bpxrficyexamplekey:193,bracket:211,brain:73,broadcast:[1,184,213,261],broke:168,broken:[20,48,89,96,133,139,157,202,212],broker:14,browser:161,brussel:184,bucket:[10,37,52,58,99,120,121,128,130,133,140,143,145,151,167,177,178,180,186,189],bucket_count:10,bucket_execution_en:147,bucketed_bi:[10,130],bug:[85,86,91,93,98,102,111,114,115,118,119,121,123,128,131,133,151,155,161,162,163,164,165,167,176,179,185,194,195],build:[1,3,31],builder:31,building:14,built:[2,7,14,31,33,35,59,69,73,166,183,188,236],bundl:[7,102,194],burncaniff:14,busi:13,button:[5,139],byqueri:212,bytea:179,bytecod:206,cacert:240,cach:[1,7,10,24,64,77,89,102,118,139,140,145,150,154,157,161,164,165,179,190,205,206,212],cafe510:14,cajol:14,calcul:[38,41,46,47,58,179,200,202,269],calendar:69,california:[43,269],call:[3,10,14,23,24,28,30,31,33,59,63,71,74,81,84,109,123,128,133,168,184,185,197,202,205,243],callabl:246,callback:[77,171],caller:89,can:[1,2,3,4,5,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,28,29,30,31,33,34,35,37,38,41,42,43,44,45,46,48,49,51,53,55,57,58,61,62,63,64,65,66,69,71,73,74,78,79,80,81,84,85,87,89,92,94,99,100,101,102,104,105,106,108,109,112,114,115,116,119,120,123,128,130,131,134,135,139,142,145,146,148,149,150,151,152,155,157,158,162,164,166,167,168,169,170,171,173,175,177,178,179,181,182,183,184,185,186,187,188,189,190,191,192,193,195,196,197,200,202,205,206,210,211,212,213,214,215,216,224,226,237,238,239,240,241,242,246,248,249,250,251,261,262,265,269,271,273,277,279,282],cancel:[83,84,95,105,132,158,166,168,169,175,205],canhandl:202,cannot:[1,7,9,20,35,46,48,83,145,206,211,238,255],canon:[55,64,69,77,226],capabl:[7,25,26,154],captur:[41,53,61,63,69,158,164,166,183],cardin:[1,7,38,47,51,168,185,214,216,269],cardinality:71,care:[1,10,202,242],caref:14,carefulli:[14,62],cartesian:[47,269],cashforevercd:14,cassandra:6,cast:[14,38,43,44,45],cat:[44,269],catalog:[7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22],catalogs:[59,130,243],categor:[116,135,155,168,203,205],categori:53,caus:[1,2,3,5,9,10,61,79,81,82,83,85,88,89,91,94,97,98,99,100,105,108,109,115,116,119,121,123,128,130,133,135,136,140,143,144,145,150,151,154,156,157,161,162,163,164,165,166,168,169,170,171,173,174,175,176,178,179,180,182,184,187,200,202,204,213,214,215,216,218,220,224,229,230,231,232,248,249,250,251,257,258,259],caution:[13,213],cbrt:52,ccc:43,cdf:52,cdh4:[154,190],cdh5:154,cdh:[10,154,230],ceil:[52,139],cell:[7,20],cent:249,central:[14,64],centroid:47,cer:242,certain:[1,43,46,80,88,101,102,116,139,140,144,145,149,151,153,154,155,156,158,162,164,167,168,169,172,177,193,196,203,206,211,212,226,239,269],certif:[64,176,182,239,240,242],certificate:176,cet:184,chain:[131,269],challeng:241,chang:[2,7,10,55,63,69],channel:185,chapter:[6,243],char2hexint:[56,84],char_octet_length:135,charact:[12,20,41,44,45,53,55,56,57,63,69,78,95,108,145,154,155,172,173,185,211],chart:41,check:[11,34,55,78,94,108,113,120,131,154,159,161,164,166,168,172,179,184,186,229,237],checkcanshowt:161,checkcanshowtablesmetadata:161,checkpoint:234,checksum:[37,92,94,142],china:105,chita:82,chmod:[14,61,62,66],choos:[1,73,86,149,204,211,241,242],chose:211,chosen:[12,24,188],chr:[55,212],chunk:[3,28,30],cipher:241,circl:47,circuit:[7,154,155],citi:[193,239,242,264,265],classif:[83,199,200],classifi:[74,196,205],classpath:[7,10,33],claus:[1,7,10,37,43,58,71,73,81,84,88,99,101,104,118,130,134,148,149,151,159,161,162,164,166,168,171,172,177,180,186,187,189,191,196,197,202,206,210,222,226,233,248,249,250,251,253,257,258,259,260,263,267],clean:[1,132,165,226],cleaner:10,cleanup:[130,182],cleanupqueri:154,clear:[89,105,227],cler:262,clerk:[58,262],cli:[2,7,11,14,34,59],click:[5,18,19,21,22,63,65,171],clientconfigur:10,clienttag:181,clock:[114,202,216],close:[9,17,47,81,173,176,186,196,213],closeabl:203,closest:47,closur:47,cloudera:10,clue:241,cluster:[1,2,3,4,7],clustered_bi:130,cms:[229,230],coalesc:[24,37,43,171],coalesce:38,code:[1,7,24],codebas:31,codec:[10,118,190],codepoint:[55,158],coeffici:37,coerc:[13,46,154,206],coercibl:189,coercion:[78,81,87,94,95,114,120,123,128,153,155,159,164,170,173,177,182,189,202,233],coincid:47,col1:[181,269],col2:181,col:181,col_famili:7,col_nam:7,col_qualifi:7,collat:14,collect:[1,9],collector:131,collis:[152,262],colloc:10,coln:269,coloc:[130,131,178],colocated_join:178,colon:[7,13,177,211],color:36,colorado:269,column:1,column_alia:[250,269],column_express:282,column_filter_optimizations_en:7,column_map:7,column_nam:[245,249],column_size:135,columnar:[24,106,123,130,132,161,205],columnar_dictionari:132,columnar_process:132,columnar_processing_dictionari:[106,108,109,132],columnarserd:202,columnblock:24,columnhandl:[77,202],columnmetadata:[81,116],columns:[18,19,21,22,59,110,148,243,254],com:[1,7,10,11,12,14,24,33,63,64,190,238,239,240,241],combin:[10,31,35,42,55,73,78,116,139,153,191,212,269],combinatori:47,combine_hash:[261,262],combinefunct:31,come:[2,37,51,92,147,202],comma:[1,7,9,10,12,13,17,20,24,30,148,176],command:[7,11,20,59,60,61],comment:[7,9,13,14,24,61,110,116,148,149,160,187,206,210,245,249,250,256,264],commit:[5,59,100,131,141,175,179,226,243],committed:280,common:[1,5,11,26,31,38,42,46,47,89,155,158,191,202],commonli:189,commun:[1,10,59,63,73,74,109,150,167,171,179,182,184,191,212,236],compact:[24,88,116,175],compar:[9,24,35,38,42,76,95,97,102,158,186,191,219,222,224,232,235,265],comparis:97,comparison:36,compil:[123,128,141,154,182,196,202,206],complement:[35,37,39,40,50,69],complet:[1,3,5,11,22,29,47,48,62,77,84,94,102,104,120,131,139,153,158,165,170,171,175,181,187,188,191,197,216,226,238,241,262],complex:[7,25,26,31],complianc:95,compliant:47,compon:[8,10,41,57,58,69,73,126,131],compos:[11,237,269],composit:55,compress:[1,10,61,63,118,119,152,182,184,190,202,230],compris:73,comput:[1,7,10,31,37,39,52,58,123,128,141,142,155,158,182,199,202,269],computation:5,concat:[38,39,51,55,89,108,109,155,161],concept:[3,28,34,59,72],concern:7,concert:73,conclus:237,concret:31,concurrent_lifespans_per_task:[178,184],concurrentmodificationexcept:180,condit:36,conf:[10,11,238,241],confid:52,config:[1,2],configur:[2,3,6],confirm:242,conform:[48,57,179,183,226],congest:128,conjunct:[43,127,269],connect:[2,7,9,10,11],connected:7,connecticut:269,connector:1,connectoraccesscontrol:[34,94,139,154],connectorcolumnhandl:[77,202],connectorcontext:139,connectorfactorycontext:139,connectorhandleresolv:[28,211],connectorid:30,connectorindex:[155,234],connectoroutputhandleresolv:211,connectorpagesink:[142,226],connectorpagesourc:[155,173,213,215],connectorpartit:[77,202],connectorpartitionresult:202,connectorrecordsinkprovid:211,connectorsess:[89,171,202,214],connectorsplit:202,connectorsplitmanag:28,connectorsplitsourc:[134,202,203],connectortablehandl:202,connectortablelayout:116,connectortablemetadata:135,connectortyp:202,connectorviewdefinit:184,consecut:[135,189],consid:[7,11,42,45,63,143,206,211,239,269],consider:239,consist:[9,13,17,20,63,73,92,109,157,164,181,212],consol:241,consolid:211,consortium:47,constant:[1,8,37,42,52,71,87,89,92,95,100,102,108,116,123,128,131,154,160,168,171,172,211,222,226,269],constrain:180,constraint:[24,68,191],construct:[38,43,47,51,71,131,148,185,202,269],constructor:10,consum:[1,2,5,8,9,11,13,14,35,73,161,163],consumpt:181,contact:[9,145],contain:[5,7,9,11,12,13,14,15,17,20,23,24,30,31,32,33,35,37,38,41,47,48,51,53,55,57,58,61,63,64,73,77,78,83,84,102,105,113,116,129,132,135,139,141,142,143,145,147,148,150,151,158,159,161,162,164,166,167,168,170,171,172,173,176,177,180,183,184,186,187,188,189,191,202,205,206,211,214,216,222,226,229,230,232,235,237,239,240,241,242,248,250,251,269],content:[1,2,8,9,10,12,13,15,16,17,18,19,20,21,22,24,25,26,33,63,77,114,166,171,190,196,235,237,240,241,242],context:[1,53,55,148,184],continu:[3,7,11,24,61,66,74,163,171,173,176,178,181,196,241],contribut:73,contributor:[27,73],control:[1,7,8,13,17,20,27,32,33],control_catalog:66,control_password:[66,229],control_postqueri:[66,100],control_prequeri:[66,100],control_queri:66,control_schema:66,control_usernam:[66,229],conveni:[7,30],convers:[7,10,13,36],convex:47,coordin:[1,5,8,11,16,29,32,33,34,47,59,63,64,65],copi:[10,139,185,212,238,240,249],core:[10,11,30,73,131,211],corp:240,corr:[37,80,169],correct:[1,10,11,17,44,55,78,95,100,108,113,120,125,131,139,142,148,149,151,155,156,159,161,164,169,177,179,183,189,190,191,206,210,226,239,242],correctli:[7,77,81,125,130,131,155,168,177,180,191,198,202,210,211,224],correl:[1,37,108,118,139,142,151,161,162,164,165,169,170,185,189,262,269],correspond:[7,20,24,25,26,30,31,48,51,55,139,176,181,183,184,269],corrupt:[14,16,43,119,150,164,170,179,189,234],cosh:52,cosin:52,cosine_similar:[52,127,134],cost:[1,167,175,202,262],could:[7,11,13,20,85,91,93,99,100,102,105,109,112,113,116,119,126,131,133,135,136,140,143,144,145,148,150,154,156,157,162,166,167,170,178,179,186,191,196,204,205,206,212,213,222,223,224,225,232],count_8:[261,262],count_if:37,counter:[173,177,198],countri:[10,191,193,239,242],court:14,covar_pop:[37,80],covar_samp:[37,80],covari:37,cover:[47,73],cow:269,cpu:[1,2,61,79,80,82,102,108,111,119,131,133,141,143,144,145,163,164,165,168,171,172,173,175,178,179,181],cpuquotaperiod:2,cql:[9,209],cqlsh:9,crash:[100,102,170,171],crc32:[39,166],crc:39,creat:[1,2,7,8,9,10,12,13],create:[2,7,8,9,10,11,16,17,18,19,21,22,59,66,68,77,87,88,99,100,113,115,118,119,130,134,139,140,149,158,160,164,168,169,180,192,200,206,209,229,237,243,244,245],createauthenticatedprincip:32,created_at:14,createt:173,creation:[8,29,79,102,110,135,146,162,183,184,186],creativ:28,criteria:[81,95,118,139,141,148,155,192,237],criterion:237,critic:[63,205],cross:[68,71,98,99,161,167,171],crt:240,cryptograph:[238,241],css:41,ctrl:[84,95,105],cube:[52,68,118,161,269],cumbersom:13,cume_dist:58,cumul:[3,52,58,110],curiou:73,curl:14,current:[1,3,5,7,10,11,12,13,23,37,38,45,54,56,58,65,79,84,89,92,94,99,100,102,105,145,154,171,186,188,191,192,205,206,211,215,237,247,248,268,269,276,277,278,279,280,281],current_d:[17,45,113,156,185],current_date:68,current_tim:[45,156],current_time:68,current_timestamp:[45,68],current_timezon:[45,218],current_us:[54,188],current_user:68,custkei:[86,211],custom:7,custom_scientist:7,customer_kei:14,customerkei:14,cyan:41,da_juanand_onli:14,daemon:[63,212],daemontool:63,dai:[24,38,45,56,58,69,102,126,131,169,175,185,191,202,225],data:[1,2,3,5,6],data_1_week:191,data_1_year:191,data_definit:2,data_definition:2,data_definition_:2,data_typ:[245,249],databas:[10,17,18],databasemetadata:[77,95,99,135,154,155,157,196],datacent:9,dataformat:[13,14,20],datanod:10,dataset:196,datasourc:196,datasourcenam:134,datatyp:7,date:[7,10],date_add:[45,77,202],date_diff:[45,77],date_format:[45,76,90,139,202],date_pars:[45,76,90,132,133,139,202],date_trunc:[45,202],datedata:24,datetim:[56,65],datetimeformat:45,day:[38,45],day_of_month:45,day_of_week:45,day_of_year:45,daylight:202,db8:69,dcawareroundrobinpolici:9,ddc4df17:12,ddl:7,deadlock:[1,3,78,79,80,109,130,139,150,181,233],dealloc:252,deallocate:[59,68,243],debug:[12,29,63,95,185,189,230],dec:45,decemb:45,decid:189,decim:36,decimal128:179,decimal:[9,35,46],decimal_digits:135,decis:[25,26,37],declar:[31,61,89,108,167,191],decomposit:55,decompress:[165,229,233],deconstruct:73,decreas:[1,3,163,168,178],decrement:173,decrypt:10,dedic:63,deem:242,default_valu:58,defaulteventhandl:14,defin:[2,7,11,12,13,14,16,17,20,24,29,31,32,33,34,35,41,45,46,47,69,73,109,164,184,186,188,206,237,246,260,269,282],definit:[2,7],defunct:154,degrad:[175,188,239],degre:[52,76],delai:[8,9,24,92],deleg:30,delet:[7,10,11,17,55,78,99,139,158,253],deleted_table_nam:17,delimit:7,deliv:[28,73],demand:1,demonstr:[42,50,269],deni:[34,237],denot:[263,267],dense_rank:58,deploi:14,deploy:[11,13,20,63,173,174],deposit:14,deprec:[76,77,98,134,139,143,148,150,154,173,176,183,186,187,188,205],depth:[11,31],dereferenc:176,deriv:[10,47,151,167],desc:[37,58,172,269],descend:[37,38],describ:[1,3,6,7,9,14,24,45,56,63,69,73,77,139,140,148,190,202,240,243,255,256],describe:[2,7,9,13,14,17,18,19,20,21,22,59,68,78,140,143,148,206,210,243],descript:[7,9,10,11],descriptor:[12,129,135],deseri:[7,48,104,116,152],design:[8,9,72,73,74,139],desir:[8,34,237,241],desiredcolumn:24,destination_st:269,destination_zip:269,detail:[5,7,10,11,17,35,65,69,84,94,98,105,113,119,135,136,139,151,164,166,168,170,181,186,193,194,206,216,237,241,246,253,262,263,267,276],detect:[14,17,81,109,131,191,196,202,212,233,262],detector:[99,190],determin:[1,24,25,26,34,47,48,52,53,58,255,269],determinist:[1,25,26,116,164,229,269],dev:[8,14,239,262],develop:14,deviat:[37,52,61],devic:[1,3,8,239],devot:30,dhadoop_user_name:10,diagnos:4,diagnost:63,dictionary_aggreg:[1,109],dictionary_processing_join:[177,179],dictionaryblock:110,did:113,differ:[1,3,6,7,8,9,10,11,12,13,14,16,17,18,19,20,21,22,24,31,33,37,46,47,48,53,55,58,61,62,69,71,73,74,92,100,123,130,140,164,172,175,176,183,186,202,206,212,238,239,241,269],differenti:175,difficult:[7,13,177],digit:[45,46,52,56,69,132],dimens:47,dimension:47,direct:[92,125,131,269],directli:[1,7,10,14,25,26,31,53,134,135,190,202,238,246,267],directori:[1,2,7,10,11,13,15,20,30,33,61,63,73,77,129,132,139,194],disabl:[1,11,61,62,77,85,89,98,99,103,108,131,132,133,158,161,164,167,168,176,177,183,185,187,188,189,206,212,216,226,229,232,239],disallow:[163,205],disappear:13,discard:[8,16,120],discov:[9,17,139,181],discoveri:[9,63,73,77,190,195,239],discuss:[10,11,246],disjoint:47,disk:[0,1],displai:[80,95,98,105,111,135,161,164,171,178,181,198,206,261],disproportion:[168,178],disrupt:103,distanc:[47,55],distinguish:[176,191,240],distinguished_name_of_the_us:240,distributed:[226,261],distributed_join:[1,87,232],divid:[2,3,52,58],divis:[43,52,71,197],djava:[11,239],djavax:240,dlog:241,dn_of_the_authorized_group:240,dness:14,dns:[64,239],doc:24,document:[5,7,9,10,11,17,28],doe:[1,2,3,7,10,11,14,24,28,30,31,37,42,45,47,54,58,63,65,73,100,113,119,129,143,149,165,167,176,184,190,191,193,196,205,212,238,240,241,248,249,250,257,258,259,269],doesn:[10,23,28,42,46,47,48,118],dog:[69,269],doi:45,dollar:53,domain:[24,88,239,240],domain_name_of_the_serv:240,domain_realm:[238,241],don:[3,7,24,28,31,47,73,222,226],done:[7,65,104,183,239],donotinitializelog:30,dot:[63,196,214],doubl:[1,10,12,13,14,17,22,24,31,37,39,41,44,45,47,48,52,65,68,69,71,95,113,153,155,177,179,185,189,204,226,232,249,273],doubledata:24,dougla:47,dow:45,down:[1,7,8,20,52,77,80,102,114,129,131,139,145,157,179,187,196,201,216],downgrading_consistency:9,download:[14,61,62,63,64,66,238,241],doy:45,dramat:206,drastic:7,drawback:1,drawn:41,drive:[1,3],drivermanag:64,drop:[1,2,7,9,10,11,13,16,17,52,59,68,77,89,127,129,130,139,150,167,168,172,179,180,182,183,184,205,206,209,243,245,248,249,251],dsun:[238,241],due:[1,13,14,78,79,80,100,102,119,133,139,149,153,155,157,159,164,165,167,168,170,173,174,178,179,180,182,183,186,192,195,196,202,226],dummi:[8,13],dump:[12,63,148,216],duplic:[38,84,116,131,164,189,206,269],durat:[1,7,24],dure:[1,3,8,16,35,63,76,80,95,102,108,129,140,141,143,156,157,162,167,169,172,180,185,186,191,196,206,219,225,240,269],dwrf:[115,132,141,170,171,176,213],each:[1,3,5,7,8,9,11,12,13,14,15,16,17,20,22,23,24,28,30,31,33,37,38,43,47,51,53,55,58,61,63,66,73,78,79,89,126,131,140,157,183,185,191,193,196,211,214,222,229,237,238,239,255,261,262,264,269],each_quorum:9,eager:175,eagerli:183,earli:[1,83,139,186,187,196],earlier:[14,227],earth:47,eas:[148,196,230],easi:[73,196,239],easier:[1,93,164,191,211],easiest:7,easili:[63,139],east:[180,269],eat:14,ec2:[10,77,95,105],edg:176,edit:55,effect:[7,37],effici:[3,73,74,82,108,114,131,172,181,191,210,212,213,216,226],egd:239,eiger:242,eight:[13,14],either:[7,10,13,17,18,19,21,22,24,31,38,41,42,50,55,69,71,108,184,186,191,237,239,240,242,269],elad:37,elaps:[154,168,173],element:[17,24,37,38,47,48,55,71,78,91,98,108,139,149,168,181,191,211,213,226],element_at:[38,51,89,131,145,171],elev:179,elig:[1,2,162,185],elimin:[1,269],els:[13,31,109],embed:[63,190],emploi:28,empti:[1,8,9,24,47,51,53,55,62,84,105,125,129,131,132,148,154,155,165,171,173,179,181,185,206,211,226,248,249,250,257],empty:47,empty_n:250,emr:10,enable_intermediate_aggreg:162,enclos:[47,159],encod:[7,13,24,35,39,48,55,56,57,78,106,107,109,137,139,141,150,161,166,167,183,189,191,205,211,214,218],encode:[39,55],encompass:73,encount:[43,102,240],encourag:196,encrypt:[10,11,105,139,154,166,239],encryptionmaterialsprovid:[10,105],end:[7,9,10],endian:39,endpoint:[10,133,139,167,239],enero:202,enforc:[2,11,129,183,188,237],engin:[24,28,31,72,128,164,193,196,202,211,214],english:[45,55],enough:[1,3,5,9,239],enqueu:185,ensur:[1,3,11,17,30,145,238,241],ensure:[164,241,276],enter:[239,242],entere:99,entir:[9,10,13,28,53,79,99,126,131,167,189,262],entri:[12,17,33,51,89,140,179,186,189,238,241],entropi:239,entrydelimit:55,environ:[10,34,54,62,63,116,164,165,175],environment:63,epitaph:14,epoch:[13,14,35],equal:[3,8,13,24,31,38,42,43,46,47,69,118,139,167,169,181,182,188,189,191,237,269],equat:102,equatablevalueset:24,equi:[52,81,104,127,131,134,170],equijoin:210,equival:[37,42,43,44,64,170,187,260,269],error:[3,7,10,11,13,14,16,37,38,42,43,46,48,58,63,77,78,83,94,97,100,102,104,107,108,116,117,118,119,129,130,132,135,136,139,140,141,143,148,150,151,155,156,157,162,164,165,167,168,170,173,176,177,179,180,181,182,188,189,190,196,197,199,200,202,203,205,206,210,211,212,220,222,224,226],errorcod:77,errornam:77,errortyp:77,es6:161,escap:[12,48,53,148,154,155,161],escape:[57,68,185],especi:[1,3,178,262],essenti:[7,31],est:262,establish:[9,17],estim:[37,118,188],estimat:173,etc:[1,2,5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,24,25,26,29,32,34,47,63,65,87,100,101,102,104,116,135,139,166,175,186,190,191,196,197,205,206,210,237,238,240,241,242],euclidean:47,euler:52,europ:[184,202],europe:269,evalu:[1,42,43,50,58,108,116,132,139,148,149,172,186,192,269],evaluat:[42,43,48,53],evaluate_classifier_predict:205,even:[1,13,14,28,42,73,145,154,171,173,176,181,202,239,269,282],evenli:[58,196],event:[9,27],eventlisten:[29,149],eventlistenerfactori:[29,33],eventu:[79,188,230],ever:168,everi:[3,7,10,11,12,18,19,21,25,26,37,48,53,63,73,76,101,139,161,164,176,193,202,211,226,239,269],everyon:[263,267],everyth:[13,55,95],everytim:251,ex1:24,exact:[79,151,167,177,178,184,237],exactli:[46,139,264,269],exactly:24,examin:73,exampl:[1,2,7],example:[11,238,241],exampleaveragefunct:31,examplecli:30,exampleconnectorfactori:30,examplefunctionsplugin:31,examplemodul:30,examplenullfunct:31,exampleplugin:33,examplerecordcursor:30,examplestringfunct:31,exce:[3,88,140,184,222],exceed:[1,3],except:[2,10,24,30,37,46,49,53,58,68,71,83,84,94,99,100,105,116,130,135,148,153,162,193,196,212,214,216],exception:241,excess:[1,37,77,79,80,164,166,168,172,173,175,185,218,220,224,229,230],exchangecli:102,exclud:[24,164,269],excluding:[141,249],exclus:[13,52],excus:14,execut:[1,2,3,5,9,10,11,12,23,28,34,35,54,61,62,63,66],execute:[59,68,243],executor:[1,196],exhaust:17,exist:[7,10,13,20,24,25,26,37,43,48,77,89,102,104,120,130,143,148,155,168,176,184,190,196,202,205,212,213,238,241,244,245,248,249,250,251,257,258,259],existing_table_nam:249,exists:[17,68,77,87,118,134,168,189,248,249,250,257,258,259],exit:[95,104,108,169,180,181],exitonoutofmemoryerror:63,exp:52,expand:2,expect:[7,24,28,35,44,48,53,74,79,89,94,95,100,105,148,164,180,181,189,191,196,202,211],expens:[3,5,7,173,185,229,230],experi:205,experimental_big_queri:[85,216],expir:[7,109,132,140,175,179,182,219,222],explain:[1,2,11,46,59,73,78,84,120,145,150,151,152,167,168,169,170,183,205,211,226,243],explan:[11,63],explicit:[14,55,69,78,196,202],explicitgcinvokesconcurr:63,explicitli:[11,44,118,183,269],explit:269,explod:[71,215],exponenti:[1,10,24,157,210,214],expos:[110,118,130,131,164,197,201],expose:[87,179,181],expr:44,express:[1,14,37,42,43,44,45,48,49,50,52,53,58,61],ext:7,extend:[7,31,74,77,78,89,170,172,184,192,203,214],extens:[42,47,61,114,202,206,212,216],extension:12,exterior:47,extern:[7,10,18,19,21,22,24,25,26,63,143,145,147,158,167,168,183,212,240],external_loc:[10,143],external_t:7,external_table_idx:7,external_table_idx_metr:7,extra:[7,9,14,148,187],extract:[14,45,48,57,61,65,68,130,156,206],extractli:237,extrem:[151,205],face:4,facebook:[1,7,12,33,63,64,74],facil:10,fact:74,factor:[1,24,25,26,71],factori:[28,30,139,154],fail:[1,2,3,5,9,13,14,16,24,38,43,44,63,77,84,89,92,98,99,100,104,108,109,112,116,120,123,127,128,130,133,135,136,139,140,143,145,150,151,156,157,158,162,163,165,166,168,170,172,173,177,179,180,181,182,184,186,190,191,196,202,206,210,212,213,219,220,224,225,226,228,241,269],failed:5,failov:9,failur:[10,11,29,43,78,91,95,97,99,100,102,123,128,131,132,133,134,135,139,141,142,145,147,148,151,153,154,159,161,162,165,166,167,168,169,170,171,173,174,176,177,179,180,181,182,183,184,185,186,187,189,190,196,197,200,210,226],failure_host:116,failure_task:116,fair:[2,3,168],fall:[1,3,41,42,206,226],fallback:[10,191],fallthrough:9,fals:[1,2,7,9,10,11,13,14,17,20,31,41,42,47,48,50,61,63,69,77,84,85,100,119,133,139,168,177,183,205,206,210,216,220,237,239,240,256],false_valu:43,fama:7,famb:7,famc:7,famd:7,fame:7,famf:7,famili:7,familiar:[14,73,206],fanci:17,far:7,fashion:261,fast:[1,5,78,191],fast_inequality_join:164,faster:[1,39,78,179,193,202,211],favor:[85,173,229,230],favorit:14,favorite_count:14,fb_compact:24,featur:1,feder:10,fetch:[1,9,14,17,48,73,132,139,157,163,179,191,226],few:[1,5,11,26,33,49,53,63,79,169,191,202],fewer:1,fffd:55,ffff:63,ffffffff:63,ffffffffffff:63,field0:186,field1:186,field_length:[8,102],file:[2,6,7,8,9],file_format:61,filecount:189,filenam:205,filesystem:[10,63,139,173,197,210],fill:[38,65,264,265],filmarsivimiz:14,filter:[1,7,9,20,38,61,71,73,88,106,124,130,131,132,139,142,146,151,154,155,160,161,166,171,176,180,185,187,188,189],filterpred:262,financ:281,find:[20,23,29,32,34,43,47,53,63,139],fine:188,finish:[3,5,82,83,91,142,154,181,186,189,196,231],finished:5,finishing:5,finit:[1,52],fire:[158,189],firewal:[17,239],first:[2,7,10,11,12,24,30,31,38,43,45,46,47,53,55,57,58,63,64,65,73,125,131,135,175,179,194,196,205,210,211,237,239,240,242,269],first_el:[38,71],first_valu:[58,80,89,206],fit:[1,3,17,41,46,213],five:[2,211,269],fix:[13,17,45,48],fixedsplitsourc:134,flag:[17,53,79,89,92,110,128,132,134,143,145,153,155,173,210,213],flat:1,flatten:[38,130,269],flood:147,floor:[52,139],flush:1,fly:[25,26],fname:9,focu:[14,211,241],folder:[13,14,20],follow:[1,2,3,4,5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,24,25,26,28,29,30,31,33,37,41,42,43,45,50,53,55,56,57,58,61,63,64,65,66,68,71,73,84,85,99,139,154,170,181,188,190,196,202,205,211,214,216,237,239,240,241,242,248,249,250,262,269],foo:[7,10,69,71,256],footer:186,footprint:1,forbidden:148,forc:[3,10,132,140,175,176,206,215],force_local_schedul:[11,215],forcibl:63,foreground:63,forev:[16,85,119],form:[14,24,35,42,43,47,55,65,98,102,164,170,196,206,269],format:[7,10,13,14,20,24,30,39,41,45,56,61,63,64,69,99,115,118,119,126,130,131,141,142,153,155,170,180,181,191,192,202,205],format_datetim:45,formathint:13,formatt:14,former:150,forth:7,forward:[189,202],found:[7,9,11,24,30,33,37,38,43,51,55,78,79,196],four:[13,45,63,256],fox:14,fqdn:239,fraction:[41,45,46,47,69,168,262],fragment:[57,226,229,230,261,262],frame:[24,58,125,131,140,155,224],framed:24,framework:[7,10,31,211,213],francisco:[264,265],free:[3,82,180,183,227],freebyt:12,frequent:[1,7,35,115],fresh:83,from:[1,2,3,5,6],from_bas:[52,76],from_base64:39,from_base64url:39,from_big_endian_64:[39,150],from_hex:[39,80],from_ieee754_32:[39,187],from_ieee754_64:[39,187],from_iso8601_d:[45,84],from_iso8601_timestamp:[45,84],from_item:269,from_unixtim:[45,142],from_utf8:[55,78],front:180,frontend:240,frozen:9,fruit:197,fsync_safe:17,fsynced:17,full:[5,7,9,31,68,71,73,77,78,88,95,101,108,165,182,184,190,191,202,232,237,269],full_nam:14,fulli:[1,7,10,47,63,73,95,168,193,202,212,216,239,246],func:47,functionfactori:135,functions:[59,177,243],fundament:[73,139],fur:14,furiou:14,furniture:[14,269],further:[14,20,65,131,191,211,240,269],futur:[1,48,69,76,77,79,92,93,134,139,143,162,164,173,182,202,210,211,212,214,251],g1heapregions:63,gap:[58,185],garbag:[61,131,206,212,224],gatewai:66,gather:[171,261],general_categori:53,genkeypair:[239,242],geometr:[37,47],geometri:[47,178,179,186,189],geometric_mean:[37,95],geometry_invalid_reason:[47,185,189],geometry_to_bing_til:[47,179,189],geometrycollect:47,geometrycollection:47,geospati:36,get:[1,3,5,7,9,13,28,61,92,95,149,165,168,212,241,242],getallview:135,getblock:185,getcatalog:196,getcollect:17,getcolumn:[99,135],getcolumnclassnam:156,getcolumntyp:226,getconnect:64,getconnectorfactori:[28,30,33,135],getdatasourcenam:134,getdefault:7,getdiscretepred:116,getdoubl:31,getelapsedtimemilli:173,getfunct:[31,135],getidentifierquotestr:77,getinstanc:30,getjavatyp:35,getlargeupdatecount:105,getlong:31,getnam:[29,30,32,34],getparametrictyp:35,getpeakmemorybyt:177,getposit:179,getproperti:[89,214],getqueuedtimemilli:173,getresourcegroupconfigurationmanagerfactori:139,getschema:196,getselector:184,getservic:[135,196],getsystemt:76,gettabl:196,getter:31,gettotalbyt:173,gettyp:[35,135],gettypeinfo:157,getupdatecount:105,getupdatetyp:181,getvers:139,gigabyt:25,github:[7,24],give:[11,47,262],given:[1,5,7,10,13,17,24,28,30,31,34,37,38,39,47,51,52,58,69,73,131,250,265,269],glob:15,globa:2,glue:185,gmt:[156,175],goal:[3,30],goe:[5,190,241],gone:[48,211],gonna:7,good:[13,17,28,33,63],govern:[10,11,237],grace:7,gracefulli:176,grain:188,grammar:[191,214],grant:[10,11,18,19,21,22,59,139,161,166,186,237,243],grant_select:11,grante:[166,263,267],grants:[18,19,21,59,161,243,263,267],granular:[20,269],graphem:[55,78],graphic:5,graphviz:261,great:47,great_circle_dist:[47,185],greater:[3,37,38,42,47,52,58,112,126,131,138,139,184,269],green:41,ground:191,groundwork:210,group1:7,group2:7,group:[0,1],groupedaccumulatorst:31,groupid:[33,64],grouping:[68,118,135,161,165,166,170,177,269],grouping_el:269,gu8tn:14,guarante:[1,3,37,42,79,139,269],guava:[30,31],guess:17,guest:11,guic:30,guid:[9,11],guidelin:237,gzip:[10,118,119,202],had:[7,85,88,126,131,139,175,177,205],hadoop1:[154,190],hadoop2:[10,154,193],hadoop_user_name:10,haggl:14,haim:37,half:251,ham:55,hamming_dist:[55,171],hand:[3,7,149,164,222],handl:[1,3,7,29,30,33,42,43,50,53,57,69,74,77,79,80,84,88,89,95,102,104,105,116,118,125,126,130,131,135,139,140,151,164,168,175,177,179,194,196,197,199,200,204,206,211,213,217,219,220,234],hang:[80,85,105,155,176,179,181,184,187,190,195,202,212,213,214],happen:[30,31,34,88,115,183,186,189],hard:177,hardconcurrencylimit:[2,173],hardcpulimit:2,hash_cod:[261,262],hash_partition_count:77,hashaggreg:213,hashvalu:[261,262],hashvalue_10:[261,262],hashvalue_9:[261,262],have:[1,2,3,7,8,9,10,11,12,13,14,16,17,18,19,20,21,22,24,28,30,31,32,34,38,42,47,48,55,61,63,73,77,78,81,89,92,95,98,99,104,110,114,115,116,120,134,135,136,139,141,142,147,161,163,164,166,169,170,171,172,173,176,177,178,179,180,181,183,184,185,186,188,189,191,192,193,196,202,203,205,206,210,211,212,216,223,225,226,234,237,238,239,240,241,246,253,263,267,269,276],having:[58,68,177,197],hbase:191,hcatalog:153,hdf:10,hdfs_user:10,hdp:10,header:[24,109,142,180,185,186,189,202],health:182,heap:[1,63,131,132,144,145,171,229,230],heapdumponoutofmemoryerror:63,heartbeat:232,heavi:7,heavili:[1,9,12,114,143,212,216],hello:42,help:[1,4,7,9,61,62,63,139,179,230,238,241],helper:185,henc:263,here:[7,13,20,24,28,42,63,238,241,246],heterogen:72,heurist:[1,85],hex:[39,128,211,216],hexadecim:[56,57],hh24:56,hidden:[13,14,17,20,24,77,105,145,170,172,186,196,206,229],hierarch:91,hierarchi:[63,73],high:[1,7,8,10,24,35,41,83,95,144,145,165,170,171,178,179,182,185,202,239,241],high_color:41,higher:[1,73,141,168,170,177,202],highest:[13,269],highli:[10,13,17,26,128,161,176,202,219,222],hint:13,hiragana:53,histogram:[37,52,87,99,181,182,216],histori:[12,77,79,122,128,131,139,179],hit:[1,102],hive:[1,6],hive_storage_format:181,hiveql:[10,71],hivesessionproperti:89,hivesplitsourc:195,hll:24,hmac:39,hmac_md5:[39,186],hmac_sha1:[39,186],hmac_sha256:[39,186],hmac_sha512:[39,186],hold:[1,7,13,20,31,35,63,248],hole:6,home:238,honor:131,hopper:7,horizont:41,hors:73,hortonwork:10,host1:[9,13,17],host2:[9,13],host:[9,10,11],hostnam:[11,13,17,20,64,65,145,171,239,242],hotspot:12,hour:[45,56,69,90,175,179,202,206,210],household:[14,269],how:[2,7,10,13,14,23,28,58,73,79,89,115,190,196,261,269],howev:[1,3,7,8,10,13,16,35,48,53,64,79,237,239,240,241,269],href:24,html:[65,120],httpproxi:64,https:[10,32,64,131,139,185,238,239,240,241,242],hud:164,hundr:[1,229,230],hyperbol:52,hyperloglog:[24,105],hyperloglogdata:24,i0b10bb0aymmc:14,i32:24,i64:24,i_categori:1,i_current_pric:1,iam:10,iana:[45,238,241],icon:98,id_str:14,idea:14,ideal:13,idealli:1,idempot:162,ident:[7,11,23,25,26,35,38,140,147,164,185,269],identifi:[24,33,57,63,68],idl:[1,3,17,23],ieee:[13,39,69],ignor:[8,11,13,24,37,56,84,105,118,132,134,160,172,173,176,180,181,182,187,196,226,233],ignore:[25,26,78,167,177,206,229],ignoreexist:173,imbal:177,immedi:[9,16,202],immut:[10,102],immutablelist:30,immutableset:31,impact:[1,48,63,205,210,239,269],imperson:[7,10],implement:[2,3,7,10,24,28],implic:44,implicit:[69,78,81,87,94,153,155,159,164,170,173,177,185,202,216,233],implicitli:[154,206],importantli:1,imposs:48,improp:[149,159],improv:[1,77,78,80,92,105,106,109,115,132,154,157,164,167,169,177,182,191,193],improve:[76,77,80,82,84,85,88,95,100,102,105,106,108,113,116,118,119,120,128,130,131,132,135,137,139,140,142,143,146,148,149,150,151,152,153,154,155,156,157,158,161,162,163,164,167,168,169,170,171,172,175,176,177,178,179,180,181,183,185,186,188,189,203,205,210,212,218,221,222,226,229],in_reply_to_screen_nam:14,inaccess:16,inadvert:202,includ:[1,2,9,10,23,24,31,33,37,38,42,46,53,57,63,69,73,74,139,150,162,166,173,182,184,186,187,191,196,202,205,209,210,213,226,238,241,249,256,265,269],include:[130,139,153,181,184],including:[141,249],inclus:[13,132],incompat:[77,78,81,89,94,95,110,116,134,135,139,142,173,177,191,192,196,202,203,205,211,214,225,226,234],incompatibleclasschangeerror:186,incomplet:196,inconsist:[63,130,222,269],incorrect:[1,55,78,84,88,98,99,101,105,112,116,120,121,124,127,128,129,130,131,138,139,140,141,145,150,154,159,166,167,172,176,179,180,182,185,187,188,198,212,216,224,225,229,232],incorrectli:[53,125,126,131,135,142,148,164,170,184,186,196,225,239],increas:[1,3,9,13,79,83,99,102,115,130,131,163,168,172,175,182,185,189,196,211],increment:[38,173,185],indefinit:[17,181,187],independ:[3,24,37,95,126,131,241,269],indetermin:164,index_cardinality_cache_polling_dur:7,index_column:7,index_lowest_cardinality_threshold:7,index_metrics_en:7,index_rows_per_split:7,index_short_circuit_cardinality_fetch:7,index_threshold:7,indexablekei:24,indexcolumnnam:24,indic:[11,31,47,119,139,145,164,237,256,269],individu:[28,30],ineffici:3,inequ:[164,179,222],inet:9,inetorgperson:240,inexact:69,inf:33,infer:184,infin:[52,220],infiniband:239,infinit:[24,26,52,172,180,208,213,233],infiniti:[52,226],influenc:3,inform:[1,4,5,7,9,11,12,13,17,23,30,31,35,54,63,73,102,105,148,150,162,168,171,179,185,226,232,238,241,242,262],informat:7,information_schema:[25,26,110,161,178,180,181,182,184,186,206,215,220,222,281],infouri:120,infrastructur:[10,210],inher:47,init:99,initi:[23,30,38,63,85,102,115,128,131,139,167,169,191,206,216,239],initial:226,initial_splits_per_nod:115,initialst:38,inject:[135,196,205,233],injector:30,inlin:[71,149,197,282],inner:[1,68,78,84,104,108,154,170,186,187,192,222,269],input:[1,2,31,37,38,41,42,45,47,48,52,55,58,59,73,80,100,113,118,123,128,134,139,140,150,152,156,166,170,173,179,185,189,191,213,216,222,243],inputformat:193,inputfunct:[31,38],insensit:[1,13,37,53,56,105,120,139,216],insert:[2,7,8,10,11,16,17,55,59,68,77,99,102,108,113,118,120,132,135,145,147,157,158,164,167,179,180,211,229,237,243,263],insid:[12,24,47,63,98],inspect:196,instabl:[3,151],instal:[1,10,14,29,32,33,34,63,73,186,238,241],instanc:[1,2,7,10,17,18,19,21,22,24,28,29,32,33,34,53,55,63,69,73,77,123,130,139,167,212,262],instancenam:22,instant:[69,202],instanti:73,instead:[1,2,7,10,13,18,19,21,22,43,45,48,53],instruct:[14,98,104],instruction:[238,241],instrument:[12,197],insuffici:[5,170],int32:[167,169],int64:[167,169],integ:[1,10,22,24,37,38,40,44,52,55,69],integer:[7,9,38,48],integerdata:24,integr:[14,24],intend:[27,92,194],intens:[1,3,239,241],intention:139,inter:1,interact:[9,62,73,74],intercept:37,interchang:42,interconnect:73,interest:[28,29,30],interfac:0,interior:[47,48],interleavedblock:[170,171],intermedi:[3,73,79,100,130,162],intermitt:[157,164],intern:[7,11],interpol:41,interpret:[13,35,52,55,63,126,131,182,184,206,226,238,269],interrupt:[77,80,95,108],interruptedexcept:157,intersect:[7,38,47,68,130],intertwin:205,interval:38,intra:130,introduc:[3,77,78,92,105,149,164,179,181,187,195,196,200,204,239],intuit:132,invalid:[13,20,43,47,48,55,77,78,88,100,113,118,132,135,151,155,164,170,179,181,183,196,232,240],invalidrang:78,invent:74,invers:[48,52,57,169],inverse_normal_cdf:[52,173],invert:175,investig:5,invoc:155,invok:[29,38,53,92,171,238,240],invoke:58,invokeexact:31,involv:[23,42,73,79,92,100,102,105,131,140,148,154,156,161,162,164,177,179,185,189,196,222,225,226,240],iops:230,ipc:132,ipv4:69,ipv6:69,iron:14,irrelev:179,is_equal_or_nul:31,is_finit:52,is_infinit:52,is_json_scalar:[48,183],is_nan:52,is_nul:31,is_partition_kei:110,iscoordin:139,isequalornullfunct:31,isequalornullslic:31,ish:139,isnul:31,isnulldoubl:31,isnullfunct:31,isnulllong:31,isnullslic:31,iso8601:[13,142],iso:[13,14,45],isol:[33,105],isolation:280,issu:[1,4,7,81,84,89,91,99,100,101,102,104,105,108,112,114,116,118,119,120,125,128,131,134,135,139,140,142,145,148,149,150,151,153,154,155,157,158,159,160,161,163,164,165,166,169,170,171,173,174,175,177,179,182,183,189,196,197,198,203,207,210,216,220,221,222,224,225,226,233,238,241],item:[1,37,193,196,253],iter:[7,79,155],iterabl:30,iterative_optimizer_timeout:155,itself:[7,12,13,20,63,71,73,166,211],ivhziaperb:14,jackson:33,jan:45,januari:[45,225],japanes:202,jar:[7,14,33,61,62,64,66,196,201,238,240],java:[7,10,11,12,13,14,31,33,35],java_home:240,javadoc:35,javax:[176,205],jbod:3,jce:[238,241],jdbc:[2,18,19,21,22,59,60],jdk:[139,223],jersei:[43,269],jmola:14,jmx:[1,2,6],jmxexport:2,job:74,joda:[13,14],jodatim:45,john:42,join_column:269,join_condit:269,join_typ:269,joni:1,jose:264,josnys:14,journal_safey:17,journaled:17,jre:[238,240,241],json:[2,5,10,11],json_arrai:48,json_array_contain:48,json_array_get:[48,139],json_array_length:48,json_extract:[48,118,155,211],json_extract_scalar:[14,48,155,211],json_format:[48,92,93,111],json_pars:[48,93,111,170,173],json_parse:92,json_path:48,json_siz:[48,209,210],jsondata:24,jsonmodul:30,jsonpath:48,jsonserd:153,jul:14,just:[7,26,30,31,73,109,238,239,241],jvm:[1,3],jwt:186,jxm:1,k7mdeng:193,kadmin:[238,241],kafka:6,kafka_kei:14,kafka_tpch_0811:14,kdc:[11,238,241],keep:[1,7],kei:[1,7,9,10,11],kept:[1,8,17],kerber:11,kerberos:10,kerberosconfigpath:64,kerberoscredentialcachepath:64,kerberoskeytabpath:64,kerberosprincip:64,kerberosremoteservicenam:64,kerberosusecanonicalhostnam:64,key1:216,key2:216,key:[9,66],keyalg:[239,242],keypass:242,keyspac:9,keyspace:9,keystor:[59,64,176,236],keystore_password:[240,241],keytab:10,keytool:[239,240,242],keyvaluedelimit:55,keyword:[55,59,67],kill:[3,5,23,92,108,109,120,171,173,178,246],kill_queri:23,killer:[92,178],kilomet:47,kind:74,kindl:14,kinit:241,klist:241,kms:[10,139,141,154],kmsclientprovid:131,know:[35,74,196],knowledg:262,known:[1,7],krb5:[11,118,185,238,241],ktadd:[238,241],kurtosi:[37,158],kvpyuhcplrb84wgaigv6sypzq7tj:14,label:205,lack:[5,205,226,269],lag:[58,80,89,172,209,217],lai:[191,210],laid:269,lambda:36,lang:[12,14,55],languag:[10,24,35,43,55,59],larg:[1,3,28,30,72,74,79,97,102,105,106,107,119,126,131,139,143,149,150,151,162,168,169,172,173,174,182,195,196,197,198,200,212,214,221,226,229,269],larger:[1,55,58,63,73,78,178,191,205,211,213,230,238,241],largest:[3,37,42,46,92,178],last:[2,10,14,31,38,47,51,55,58,113,139,180,239,242,269],last_el:71,last_valu:[58,80,89,206],lastli:66,latenc:[1,108,185,191,196,197],latent:[114,216],later:[1,3,12,13,17,20,265],lateral:[71,167],latitud:47,latitude1:47,latitude2:47,launch:63,launcher:[14,63],layer:[136,212],layout:[84,205,226,261,262],lazi:[77,114,216],lazili:181,lazybinarycolumnarserd:[191,192],lazyblockload:227,ldap:[59,64,154,182,236,237],ldap_serv:240,ldaps:240,lead:[3,8,46,55,58,69,80,89,170,179,209,217],leaf:[1,115],leak:[76,78,82,83,89,102,103,110,115,119,122,128,132,135,139,147,151,152,161,166,168,172,173,177,183,196,202,203,219,226,227,228,231,232],learn:[31,37],learn_classifi:205,learn_libsvm_classifi:206,learn_libsvm_regressor:206,least:[1,5,9,13,17,20,37],leav:[13,63,167,239],lee:7,left:[43,55,68,77,101,149,159,164,170,186,269],leg:176,legaci:[1,11,110,129,134,139,141,142,148,150,154,168,178,183,186,187,188,211],legacy_join_us:183,legacy_orc:61,legacy_order_bi:[148,166],legacy_round_n_bigint:186,legacy_row_field_ordinal_access:186,legal:71,length:[8,24,37,38,39,47,48,55,56,61,69,105,106,113,153,166,179],lengthi:1,less:[1,7,37,38,42,47,52,55,62,169,178,180,181,186,211],let:[65,239],letter:[139,197,239,242],level:[3,9,33,35,47],levenshtein:55,levenshtein_dist:[55,154,156],leverag:7,lexicod:7,lexigraph:7,lib:[7,240],libsvm:206,lie:[47,52],lifecycl:139,lift:7,lightli:94,like:[1,3,5,7,8,17,18,19,20,21,22,24,34,35,42,43,44,48,53,62,63,66,68,71,74,76,79,130,135,140,154,185,186,188,196,205,210,211,212,233,249,271,277,279],likelihood:165,line:[11,13,30,33,41,47,53,59,60,61],line_locate_point:[47,186,189],linear:[1,37,145,214],lineitem:[14,61,253,269],linestr:47,linestring:47,linger:9,link:5,list:[1,2,5,7,9,10,11,12,13,14,17,18,19,20,21,22,23,24,26,28,33,43,45,63,68,73,91,97,98,99,100,102,116,129,135,139,142,154,164,171,180,182,184,186,189,197,202,205,211,214,238,241,242,248,249,250,252,255,256,264,269,271,272,275,276,277,278,279],listen:27,liter:[24,35,45],lithuanian:55,littl:[7,85],live:13,lname:9,load:[1,3],loadcommand:14,loader:[14,33,139],local:[1,3,6,7,9,10,14],local_one:9,local_quorum:9,local_serial:9,localexchang:[261,262],localfil:15,localhost:[7,14,62,64,66],locality_group:7,localtim:45,localtime:68,localtimestamp:[45,68],locat:[7,10,11,13,14,15,20,24,47,63,64,99,102,118,139,154,155,219,220,237,238,240,241],lock:[77,98,114,171,235],log10:52,log2:52,log:[1,3,7,10,11,14,15,29],logarithm:52,logger:63,logic:36,logical:261,login:188,longanddoublest:31,longer:[3,7,9,85,104,105,130,157,170,171,178,186,191,205,206,211,212,214],longest:154,longitud:47,longitude1:47,longitude2:47,look:[7,28,30,31,33],lookup:[7,24,64,102],loop:[169,172,180,208,213,233],loos:[37,71],los_angel:[45,69,131,202],loss:16,lost:[16,119],lot:[3,154,196,212],low:[1,7,24,41,79,92,120,168,175,178,206,253,262],low_color:41,lower:[1,24,31,52,53,55,77,83,170],lowercas:[31,55,56],lowest:[7,13,73],lpad:[55,119],lreykuwah:14,ltrim:55,lz4:[131,182,190],machin:[10,12,24,31,37,63,73,82,186,191,202],machinery:[14,269],made:[69,184,196,202,240,241],magenta:41,magnitud:[3,78],mai:[1,2,3,4,7,9,10,11,12,13,16,17,20,24,28,31,38,42,43,48,50,53,55,63,64,69,73,76,78,79,89,95,100,104,108,114,120,134,141,142,143,164,166,170,173,174,183,189,191,212,213,216,233,238,239,240,241,242,249,262,269],main:[1,5,7,13,14,63,77,205,211],maintain:[13,17,20],major:[7,191,197,205,211,238,241],majority:17,make:[1,7,9,10,13],malform:180,manag:2,mandat:171,mandatori:73,mani:[1,5,9,10,13,17,18,20,23,24,30,43,47,55,61,63,71,73,74,78,100,154,168,178,181,193,196,210,238,269],manifest:166,manipul:[7,10,246],manner:[8,12,53,57,139],manual:[16,17,45,56,239],map1:51,map2:51,map:[7,9,10,12,13],map_agg:[37,51,77,79,108,141,156,159,226],map_concat:[51,106,129,148,155,161],map_entri:[51,170],map_filt:[51,155],map_from_entri:[51,170,189],map_kei:[51,216],map_union:[37,131,141,159],map_valu:[51,216],map_zip_with:[51,180],mapblock:[170,185],mapn:51,mapreduc:[10,74,196],march:202,mark:[2,53,139,185,186,265],market_seg:14,marketseg:14,master:24,match:[1,2,3,10,11,12,14,15,17,31,35,42,43,53,61,63,93,95,99,101,113,118,119,131,132,140,143,148,149,177,178,183,184,188,189,191,196,204,206,211,222,237,238,240,241,242,253,264,269],materi:[10,139],math:[132,134],mathemat:[36,46,47],matter:[238,241],maven2:14,maven:14,max_bi:[37,79,95,98,105,151,154,158,161,167,181,183,211,222,234],max_grouping_set:189,max_initial_split_s:128,max_split_s:[11,128],maxbyt:24,maxfiledescriptorcount:12,maxim:170,maxima:47,maximum:[1,2,9,10,12,17,24,37,38,63,69,86,153,156,177,179,181,184,185,189,191,211,216,222,230],maxqueu:2,maxresponses:102,maxrun:173,maxsplitcount:24,mayb:249,mbean:[12,131,185],md5:[39,85],mean:[11,17,24,31,35,37,42,52,61,62,140,191,269],meaning:35,measur:[25,26,47,61,191],meat:30,mechan:[3,11,164,176,240],median:61,megabyt:[202,229,230],member:[17,48,74],memberof:240,memorypool:12,mention:[9,73],merg:[3,31,38,51,132,145,170,211],mess:7,meta:33,metadata_ag:7,metadata_d:7,metadata_nam:7,metastor:10,method:[7,24,28,29,30,31,32,33,35,64,76,99,105,107,110,135,139,154,162,167,173,180,184,186,196,202,226,269],methodhandl:[31,193],metric:[7,23,63,78,118,163,178,197],mg9kdtd2wbhm:14,micro:191,microsecond:45,middle:269,midnight:90,might:[1,17,73,140,226,239],migrat:59,miillisecond:14,milli:13,millisecond:[13,17,24,35,45,69,77,108,126,131,169,210,212],min_bi:[37,79,95,98,105,151,154,158,161,167,181,183,222],mind:7,minim:[63,116,170],minima:47,minimum:[1,10,17,24,37,38,47,55,63,69,86,143,178,181,188,211,223,238,241],minor:[7,78,105,154,198,199,206,210],minut:[10,45,56,69,77,206],minute:45,mishandl:164,misinterpret:[126,131],mislead:157,mismatch:[131,183],miss:[13,38,51,84,120,205,215],mistak:74,mitig:[175,212],mix:[48,64,80,142,158,164],mktsegment:269,mod:[52,139],mode:[11,17,53,65,95,128,151,175,181,280],model:71,modifi:[11,17,147,191,211],modul:[31,206],modulu:52,mondai:45,mongo:17,mongocli:17,mongod:17,mongodb:6,mongolian:53,monitor:[1,2,3,5,12,63,205,241],monopol:154,month:[38,45,56],more:[1,2,5,7,8,9,10,11,13,17,20,24,28,30,31,35,37,42,47,48,62,63,72,73,78,95,98,99,102,105,108,114,116,132,135,139,150,155,162,164,166,168,173,180,182,188,193,206,212,213,216,226,253,262,263,267,269,276],most:[1,3,4,5,10,11,24,30,31,42,45,49,55,58,73,126,131,135,164,178,186,191,202,211,239,249,269],mount:[7,10,14,18,19,21,22,63,190],move:[92,131],much:[1,3,9,10,30,31,39,77,79,89,145,211,239],multi:[10,47,53,149],multilinestring:47,multimap:[37,51],multimap_agg:[37,51,92,141,156],multimap_from_entri:[51,189],multipart:10,multipl:[1,3,8],multipoint:47,multipolygon:47,must:[1,2,7,9,10,11,12,13,14,17,19,20,21,22,24,29,31,32,33,34,37,38,42,47,48,52,53,55,56,61,63,68,71,73,99,154,170,171,178,183,193,194,205,237,238,239,240,241,242,257,264,269],mutat:7,my_arrai:[38,71],my_count:256,my_creat:256,my_databas:66,my_insert:265,my_password:66,my_queri:252,my_select1:[255,256,260,265],my_select2:[255,256,260,265],my_suit:66,my_usernam:66,mykeyspac:9,myschema:7,myseri:7,mysql:[6,10],nag:14,name:[1,2,7,8,9,10,11,12],name_to_age_map:51,namenod:[10,108],namespac:[7,202,214],nan:[52,77,177,188,220,226],nanosecond:[45,133],narrow:[7,95,241],nation:[8,14,16,250,255,256,260,261,263,264,265,267,269],nation_kei:14,nationkei:[8,14,256,260,264,265,269],nativ:[9,31,35,119,168,172,185,205],natur:[52,241],natural:68,ncwdvawne6tegvwfmrchlxak:14,nearest:[17,52],necessari:[10,14,33,43,44,73,202],need:[1,3,7,9,10,11,13,17,18,20,23,24,28,31,33,53,55,63,65,73,77,81,89,95,100,108,110,116,134,135,139,142,145,147,167,173,176,177,182,191,192,196,202,203,211,225,226,229,232,234,238,240,241,242],neg:[17,38,45,48,55,58,89,102,126,131,175,183],negat:[46,95],neglig:239,neither:269,nest:[78,100,104,139,148,149,169,219,269],net:[10,18,19,21,63,64,65,237,240],never:[69,140,173,224],new_column_nam:245,new_nam:[244,245],new_ord:264,newer:179,newli:[10,202,248,249,250],newlin:211,next:[3,7,13,16,24,66,98,149,168,202],nexttoken:24,nfa:1,nfc:[55,166],nfd:[55,166],nfkc:[55,166],nfkd:[55,166],nobodi:10,noclassdeffounderror:[130,131,141,167],nodemanag:[139,196],nodeschedul:12,nohostavailableexcept:9,non:[1,7,9,10,12,13,24,31,37,38,42,43,47,53,55,77,84,88,95,97,102,105,108,110,116,118,123,127,130,131,132,134,139,140,141,142,143,145,150,152,155,156,158,164,167,169,170,171,172,179,180,181,183,186,190],noncharactercodepoint:53,none:[7,10],nonexist:180,nor:206,norandkei:[238,241],normal:[5,17,23,37,52,55,61,62,84,155,191,202,210,269],normal_cdf:[52,180],normal_group:240,normalize:68,nosuchelementexcept:98,not_json:48,notabl:53,note:[3,7,9,10,13,30,31,42,48,55,59,61],noth:109,notif:[95,154],now:[8,14,45,76,79,88,89,92,95,98,99,100,104,105,108,110,115,118,120,129,135,139,141,147,149,154,155,157,161,177,179,182,185,186,187,188,191,193,196,197,202,203,205,206,209,210,211,212,213,214,216,218,219,222,224,225,226,232,233,234],npe:[79,219],nth_valu:[58,80,89,206,217],ntile:[58,222],null_replac:38,nullabl:[38,110,139],nullallow:24,nullpointerexcept:[108,150,201,233],nulls:269,nullscount:170,nullsfract:170,num_prec_radix:135,number:[1,2,3,5,7,8,9,10],numer:[7,37,43,44,45,139,167,196,212,216],numeric_histogram:[37,216],o_orderd:269,oakland:264,object:[1,7,10,12,13,17,20,28,30,31,33,35,47,48,69,77,79,80,88,89,115,146,166,183,184,185,196,229,248],object_nam:12,object_not_read:179,objectclass:240,objectclass_of_us:240,observ:174,obtain:[30,241],occasion:102,occur:[10,11,37,63,99,104,108,151,157,167,170,177,181,182,183,184,212],occurr:[38,53,162],odbc:[240,241],off:[24,102,105,106,109,149,185,189,210,216,219],offer:237,offlin:[181,182,186,206],offload:[1,3],offset:[13,14,45,58,102,156,179,217],often:[1,74,78,194,196,269],ogc:47,olap:74,old:[76,92,111,130,135,143,167,173,183,188,210],old_italic:53,older:[126,131,161],oldest:[185,211],olditalic:53,oltp:74,omit:[13,20,269],onc:[2,7,95,104,116,175,176,189,269],once:[2,17,104],one:[9,11,30],one_1:51,onli:[1,5,7,9,10,11,13,19,20,21,22,24,29,30,31,42,43,47,51,53,55,61,63,65,71,76,79,84,88,94,99,105,118,128,129,139,150,154,157,167,168,169,170,172,181,182,186,189,191,196,202,205,211,215,222,237,239,240,253,269],online:74,only:[7,10,20],onto:[3,13],oom:[1,165,229,230],open:[10,12,23,47,74,157],openfiledescriptorcount:12,opengis:47,openjdk:186,operand:46,operatingsystem:12,operator_memory_limit_before_spil:170,operatordepend:31,operatortyp:31,oppos:[48,118],optimize_hash_gener:[1,266,270],optimize_index_en:7,optimize_locality_en:7,optimize_metadata_queri:118,optimize_mixed_distinct_aggreg:[142,164],optimize_split_ranges_en:7,optimized_reader_en:[61,215,216,266,270],option:[2,7,9,10,11,13,17,20,24,30,34,38,61,62,63,69,77,79,83,84,85,92,95,102,118,119,130,134,139,142,148,149,150,152,154,155,157,158,161,162,164,167,168,169,179,181,183,184,185,186,187,188],oracl:[74,238,241],orc:[10,61,77,78,88,89,90,100,113,115,118,120,129,131,132,137,139,151,162,164,165,167,169,170,171,172,176,178,179,181,182,183,184,185,186,187,188,189,213],orc_bloom_filters_en:139,orc_optimized_writer_en:169,orc_optimized_writer_max_stripe_s:184,orc_string_statistics_limit:184,orc_tiny_stripe_threshold:189,order:[1,3,7,10,11,14,17,24,31,33,37,38,52,55,58,63,68,78,84,86,97,99,105,112,113,118,139,140,145,148,149,155,159,162,164,166,168,172,177,180,183,184,186,187,188,192,197,206,211,216,222,224,230,234,249,250,251,253,262,263,264,267],order_d:[99,250],order_id:99,order_info:99,order_region:99,orderd:[17,58,86,192,211,249,250,251,262,269,273],orderkei:[17,58,249,251,253,269,273],orders_by_d:[192,250,251,258,259],orders_column_alias:250,orderstatu:[17,86,211,249,251,273],ordin:[77,113,183,186,269],ordinality:[76,269],ordinalposit:81,org:[10,14,153],organ:[73,77,239,242],organiz:[239,242],orient:[213,226],origin:[5,10,23,134,153,202],origin_st:[43,269],origin_zip:[43,269],originalconstraint:[261,262],other:[1,2,3,5,7,8,9,11,13,20,24,26,28,29,30,32,33,34,35,38,42,47,53,57,63,64,65,66,69,73,74,76,91,92,105],other_cli_argu:240,otherst:31,otherwis:[7,13,34,37,38,43,176,202,206,253,264,269],our:[31,191],out:[1,2,3,20,23,31,43,46,47,65],outcom:[42,181],outer:[1,68,78,101,105,108,127,131,134,139,141,150,164,182,189,269],outlier:1,outofmemoryerror:[1,63,140,162],output:[1,2,5,7,31,38,59],outputcolumnnam:24,outputconstraint:24,outputfunct:[31,38],outsid:[10,41,47,63,89,100,105,189,241,269],outstand:[1,177],over:[1,3,7,17,24,30,37,58,72,73,74,81,86,100,102,107,131,132,145,157,161,164,167,168,172,175,177,179,181,189,191,193,195,198,202,206,211,212,215,220,226,238,240,241,251,262],overal:[1,115],overcom:3,overestim:163,overflow:[128,139,184,196,202],overhead:[1,61,163,164,166,168,170,171,173,175,183,184,185],overlai:240,overlap:24,overload:1,overrid:[10,30,31,33,176,214,237],overridden:[1,14,62],overutil:1,overwritten:7,own:[7,10,11,33,186,237,246],owner:[11,95,135,184,186],ownership:11,p332a:43,p4hyperloglog:105,pacif:82,pack:7,packag:[7,14,33,43,63,85,102,139,196,206,207],package_weight:269,pad:[41,55,119,269],padstr:55,page:[3,5,7,8,16,20,65,77,80,84,105,109,111,113,115,119,120,122,128,139,141,151,164,167,170,171,175,178,181,183,185,189,212,216,226],page_processing_delai:[8,139],page_url:10,page_view:10,pageindex:189,pager:[95,108,169,180,181],pages_per_split:8,pagesink:177,pagesort:189,pagetoolargeexcept:102,pagin:62,pair:[7,13,20,37,51,53,55],parallel:[1,5,37,73],param:24,paramet:[3,10,20,23,30,31,35,41,42,52,57],parameter1:260,parameter2:260,parameter:184,parametrictyp:[33,35],parent:[2,205],parenthes:269,parenthesi:[45,53,54],parquet:[10,77,80,91,95,102,113],parquet_optimized_reader_en:114,parquet_predicate_pushdown_en:114,pars:[13,14,45,56,69,73,102,117,126,130,131,133,145,165,166,173,177,185,202,211,212,219],parse_datetim:45,parse_decimal_literals_as_doubl:[69,177,185],parse_dur:[45,163],part:[3,7,10,13,14,17,20,24,31,46,54,69,139,155,194,202,205,211,240,269],parti:[73,74,201],particular:[1,7,11,20,25,28,30,33,35,44,47,63,65,71,73,89,185,211,212,226,237,269],particularli:[1,105,269],partion:9,partit:[1,3,9,10,13,14,28,30,58,77,78,79,80,84,85,86,87,99,102,108,110,113,116,119,120,122,128,130,131,139,140,143,146,148,149,153,157,164,167,169,171,177,178,179,180,181,183,184,186,187,188,191,192,196,198,202,206,211,212,213,214,216,221,226,232,261,262],partition:[58,86,149,154,164,196,211],partitioned_bi:[10,99,273],partitionresult:202,partitions:[180,186,188,189,215],partsupp:14,pass:[1,3,7,10,24,29,32,34,41,51,53,64,73,88,168,238],password:[7,9,17,18,19],passwordauthent:32,passwordauthenticatorfactori:32,pattern:[1,15,45,53,95,154,240,271,277,279],paul:42,paus:[1,77,163,182],payload:149,peak:[3,113,153,178,179,180,181,183,186,189],peer:[9,58],penalti:2,peopl:245,pequitamedicen:14,per_packag:43,perceiv:[55,78,170],percent_rank:58,percentag:[2,5,37,58,100,188,269],percentil:[37,113],perform:[1,3,4,8,9,10,11,13,17,20,23,25,26,29,31,34,39,45,46,52,53,55,58,61,63,69,71,73,77,78,80,86,88,95,100,102,105,106,107,108,109,110,116,118,119,120,128,130,131,132,134,135,137,139,140,142,145,146,148,149,150,151,152,153,154,155,156,157,161,162,163,164,165,167,168,169,170,171,172,173,175,176,177,179,180,181,183,184,185,186,188,189,191,193,197,198,202,205,206,209,210,211,212,213,218,221,222,237],period:[1,2,12,131,179,182],perman:81,permiss:[9,10,11,34,95,131,139,150,159,186,226],permit:[11,237],permut:38,persist:5,person:[2,240],perspect:74,petabyt:74,peucker:47,phase:119,phone:14,php:24,physic:[13,73,77,102,178,269],pick:[7,33,212],pig:[74,269],piggyback:189,pin:[10,105],ping:132,pinto:14,pipe:[7,164],pipelin:[2,74],pipeline_:2,place:[1,2,14,33,38,52,234,265],place_nam:14,placehold:[11,240],placement:226,plan:[1,5,73,77,84,85,89,94,97,100,102,108,112,113,114,115,118,130,131,139,140,143,145,147,148,151,154,156,157,158,159,161,162,163,164,166,169,170,171,175,176,177,179,180,181,183,185,186,188,198,203,206,211,212,214,218,221,225,226,233,261,262],plane:47,planner:[79,105,123,128,199,202,226,232],planning:5,platelet:14,platform:10,pleas:[3,7,10,17,20,186,205,206,214],plu:[58,249],pluggabl:[2,7],plugin:[7,10,17,27,28,29],plus:77,point:[2,9,10,24,30,33,39,47],pointer:94,poland:264,polici:[2,9,131,176,178,179,184,185,212,226,233],poll:[7,212],polygon:[47,186],pom:33,pool:[12,14,17,171,180,188],poolsiz:1,poor:107,popul:37,popular:42,port:[5,9,10,13,14,17,20,24,57,63,64,65,131,135,154,180,213,238,239,240,241],portion:[47,191],portnumb:22,posit:[13,17,38,48,52,55,77,84,113,126,131,162,169,179,246,255,269],position:102,possess:[263,267],possibl:[3,5,9,10,11,13,20,24,37,44,73,77,79,100,102,109,132,161,167,178,186,191,233,238,239,241,269],post:100,postgresql:6,potenti:[1,5,78,80,120,122,128,130,132,135,139,140,142,146,150,162,168,172,177],pow:[52,91],power:[1,7,52,91,139,186,269],practic:[3,7,11],pre:[80,100,111],precaut:11,preced:[58,104,269],preceding:[58,125,131],precis:[39,46],precision:139,precomput:235,predic:7,prefix:[7,10,14],preload:14,prematur:82,prepar:[2,139,140,148,172,252,255,256,260,265],prepare:[59,68,243],preprocess:164,preregistr:214,presenc:42,present:[13,16,20,51,79,120,150,151,164,184],preserv:[53,63,165],press:95,pressur:[218,220],presto:[0,1,2,3],presto_certif:242,presto_home:7,presto_keystor:[240,241],presto_offlin:[186,206],presto_pager:62,presto_preprocessor:164,presto_query_id:139,presto_trust:242,presto_truststor:240,prestobatchwrit:7,prestoconnect:[202,214],prestogetindexsplit:24,prestogetrow:24,prestogetsplit:24,prestogettablemetadata:24,prestointerv:[126,131],prestolistschemanam:24,prestolistt:24,prestos3filesystem:[77,78,80],prestostat:181,prestothriftallornonevalueset:24,prestothriftbigint:24,prestothriftbigintarrai:24,prestothriftblock:24,prestothriftboolean:24,prestothriftbound:24,prestothriftcolumnmetadata:24,prestothriftd:24,prestothriftdomain:24,prestothriftdoubl:24,prestothriftequatablevalueset:24,prestothrifthostaddress:24,prestothrifthyperloglog:24,prestothriftid:24,prestothriftinteg:24,prestothriftjson:24,prestothriftmark:24,prestothriftnullablecolumnset:24,prestothriftnullableschemanam:24,prestothriftnullabletablemetadata:24,prestothriftnullabletoken:24,prestothriftpageresult:24,prestothriftrang:24,prestothriftrangevalueset:24,prestothriftschematablenam:24,prestothriftservic:24,prestothriftserviceexcept:24,prestothriftsplit:24,prestothriftsplitbatch:24,prestothrifttablemetadata:24,prestothrifttimestamp:24,prestothrifttupledomain:24,prestothriftvalueset:24,prestothriftvarchar:24,pretti:13,prevent:[1,3,11,16,88,97,105,107,111,135,139,145,150,155,158,164,165,168,169,171,177,179,186,190,196],previou:[7,24,31,66,73,77,81,89,95,102,110,116,134,135,139,142,173,177,178,181,191,211,225,226,229,234],previous:[7,77,88,90,95,104,113,126,131,132,135,147,154,155,167,170,173,175,179,180,181,183,184,185,186,189,196,202,205,211,212],price:[58,192,249,250,251],primari:[7,30,190],primarili:[8,175,176],primary:[9,17,66],primary_preferred:17,primit:[13,31],princip:10,principal_to_us:237,print:[45,84,89,95,181,202],printadaptivesizepolici:4,printclasshistogramafterfullgc:4,printclasshistogrambeforefullgc:4,printflsstatist:4,printgcapplicationconcurrenttim:4,printgcapplicationstoppedtim:4,printgccaus:4,printgcdatestamp:4,printgcdetail:4,printgctimestamp:4,printreferencegc:4,printsafepointstatist:4,printsafepointstatisticscount:4,prior:[240,241],priorit:168,prioriti:[2,168,177,253],privat:[11,64],privileg:[2,11,263,267],privileges:[263,267],probabl:[34,52,241,269],probe:[79,115],problem:[4,10,126,131,196,238,241],procedure_nam:246,process:[1,2,3,5,7,10,11,14,20,23,28,30,52,58,61,63,73,74,76,100,106,120,123,130,132,143,144,145,161,163,166,173,177,178,179,181,188,189,193,196,205,206,216,238,241,269],processcputimemean:61,processcputimep50:61,processcputimestd:61,processing_optim:[132,161],produc:[1,8,13,14,35,37,39,42,43,45,47,48,58,63,73,74,84,85,88,92,100,104,108,116,120,127,132,134,139,140,141,142,145,149,154,157,162,164,167,176,186,189,196,202,216,224,225,264,269],product:[63,169,205,240,269],program:[14,61,62,164],programat:7,programmat:[7,176],progress:[77,79,113,131,164,171,214,216],prohibit:237,project:[7,47,61,74,80,102,106,161,189,206,238,241,261,262],prompt:[179,240,242],proof:205,prop:53,propag:[193,196],proper:[7,196,210],properli:[1,7,8,16,48,84,89,105,109,141,147,179,191,196,222,239],properti:0,properties:[141,249],property1:[29,32,34],property2:[29,32,34],property_nam:[248,249,250],proport:[2,171],prospect:74,proto:189,protocol:[9,10,24,57,173,176,189,238,241],provid:[3,5,7,9],provinc:[239,242],provis:10,proxi:[24,64,167],prune:[119,145,180,216],pseudo:52,publish:196,pull:1,punctuat:56,pure:69,purg:158,purpos:[1,13,39,73,74,190],push_aggregation_through_join:[1,164],push_partial_aggregation_through_join:164,push_table_write_through_union:1,pushdown:[7,114,154,155,163,167,170,184,186],put:[2,7,13,14,20,74,104],pwd:14,q3rqzlzct1:14,quadkei:47,quadrat:78,qualifi:[7,10,13,20,63,73,95,128,142,164,168,185,191,193,239,246],qualiti:[13,39],quanta:168,quarter:[45,251],query_id:23,query_max_execution_tim:173,query_max_memori:[3,83],query_max_memory_per_nod:3,query_max_run_tim:92,query_prior:2,querycompletedev:[172,184,185],querycompletionev:116,querycputimemean:61,querycputimep50:61,querycputimestd:61,querystat:[173,177],querytyp:[2,186],question:265,queu:[1,2,9,23,85,132,139,157,167,173,196,216],queue:[2,76,77,91,99,132,166,173,185,216,219,232,233],queued:5,queuedtimelimit:2,quickli:[1,7,262],quit:13,quorum:[9,14],quorumpeerconfig:14,quot:[12,48,63,68],quota:[2,133],race:[82,91,99,100,109,116,119,123,130,133,136,157,182,196,213,214],radian:[52,76],radix:52,raid:[1,3],rais:[38,46,52,108,154,189,251],ram:16,ramp:178,ran:[23,61],rand:[52,197],randkei:[238,241],random:[38,52,108,238,239,241,269],randomli:[84,133],rang:[7,9,24,37,41],range:58,rangevalueset:24,rank:37,rankingwindowfunct:135,raptor:128,rare:[110,115,116,139,157,167,170,183,185,206,225],rate:[8,164],rather:[1,10,31,37,48,53,76,84,90,105,108,125,126,130,131,134,135,139,155,171,176,177,178,184,188,189,206,212,226,240,251],ratio:[1,7,186],raw:5,raw_dat:14,rawdatas:189,rcbinary:[10,210,212],rcfile:[10,139,142,155,164,167,168,172,178,191,192,202,208,212,215,217],rcfile_optimized_reader_en:139,rcfile_optimized_writer_en:155,rctext:210,reach:[1,2,120,238,241],reactjs:77,read:[1,2,3,7,8,9,10,11,13,14,16],readabl:[11,61,88],reader:[61,73,88,89,90,91],readi:[33,205],readme:[7,194,238,241],readonlyconnectormetadata:192,real:[10,30,39,48,52],realiz:73,realm:[238,241],realtim:[132,164],reason:[1,16,47,69],reboot:[63,147],receiv:[7,63,73,95,104,191,211],recent:[5,23,189,202],reclaim:[108,205],recogn:[53,147],recommend:[1,3,10,13,14,17,48,63,169,176,192,205,212,238,239,240,241],reconnect:202,record:[24,28],recordcursor:[28,173],recordcursorprovid:211,recordkei:7,recordpagesourc:155,recordread:193,recordset:[28,155],recordsink:[177,226],recoveri:162,recreat:[16,130,139],rectangl:186,rectangular:47,recurs:[77,206],recursive:68,red:[41,214],redact:166,redi:6,redirect:241,redistribute_writ:[1,85],redshift:6,reduc:[1,7,10,17,20,38,77,79,80,100,102,114,131,140,141,143,145,146,154,157,159,161,162,164,165,166,171,173,175,176,178,180,181,182,183,184,196,202,206,216,220,229,230,235,238,241,269],reduct:191,redund:[100,113,116,145,173,199],reenabl:83,ref:47,refactor:[205,211],refer:0,referenc:[10,12,48,53,73,76,119,135,150,234,251,269],reflect:[105,155],reformat:61,refus:17,regardless:[9,11,189,269],regener:240,regexp_extract:53,regexp_extract_al:[53,226],regexp_lik:[49,53],regexp_replac:[53,183],regexp_split:[53,77],region:[10,14,95,105,180,269],region_nam:180,regionkei:[255,256,260,261,264,265,269],regist:[29,32,34,63],registri:63,regr_intercept:[37,80],regr_slop:[37,80],regress:[37,97,105,106,110,119,120,130,134,135,139,140,143,144,145,149,156,157,158,162,163,165,168,177,178,179,181,187,193,196,198,200,202,204,213,218,219,222],regressor:205,reintroduc:92,reject:[2,91,132,169],rel:[1,2,33,55,154,168,262,281],relat:[3,23,28,47,73,74,77,101,180,187,202,212,240,269],releas:[16,48,59,66,69],relev:[7,31,33,63,262],reli:[7,8,238,241],reliabl:[128,175,197],remain:[29,32,34,63],remaind:[41,52,58],remot:[9,106,145,150,182,185,212,220,226,238],remote_task_error:116,remoteexchang:261,remotesourc:[261,262],remov:[11,17,38,48,53,55,76,77,78,79,81],renam:[11,61,62,66,76,77,78,79,95,118,130,132,135,139,143,150,161,162,172,173,180,184,202,211,234,244,245],rename:[95,244,245],render:[41,65,69,78,128,133,139,150,157,177,179,180,222],reorder:149,reorder_join:149,repartit:[103,122,128,239],repartition:261,repeat:[38,151,166,179,212],repeatable:280,repeatedli:132,replac:[1,7,9,10,13,17,18,19,20,21,22,24,38,53,55,63,65,74,95,115,130,135,139,148,154,170,178,183,186,188,202,215,225,237,240,251,265],replace:251,replic:[37,205],replica:9,replica_acknowledged:17,replicas_safe:17,replication:9,replication_factor:9,repo1:14,report:[1,17,30,61,74,108,118,130,135,141,170,178,179,191,196,198,262],repositori:7,repres:[13,17,20,24,38,46,47,52,69,77,169,170,171,202,261,265,269],represent:[5,24,37,39,40,46,47,52,55,56,73,89,225,234],reproduc:196,request_log:10,request_tim:10,requir:[1,2,3,7,9,10,11,13],requiredconfig:30,research:37,resembl:73,reset:[59,102,105,140,176,226,243],resid:[7,237],resili:182,resolut:[128,148,176],resolv:[1,64,141,145,222,281],resourc:0,resource_group:2,resource_overcommit:[108,120],resourcegroupid:186,resourcegroupinfo:167,resourcegroupmanag:184,resourcegroupselector:184,resourcegroupst:167,respect:[7,10,65,118,119,154,181,189,197,206,212],respect_table_format:181,respond:148,rest:[10,55,73,77,126,131,132,167],restart:[7,8,14,16,33,109],restor:[95,134,148,150,183,186,187,188,190],restrict:[1,181,211,240,269,271,277,279],result:[1,3,7,9,10,11,13,17,31,35,37,38,42,43,45,46,48,50,51,55,58,62,65,69,71,73,78,84,86,88,92,95,98,99,100,101,105,112,113,116,120,121,124,127,128,130,131,132,134,138,139,140,141,148,150,151,154,166,167,170,176,180,181,187,188,189,191,192,196,202,206,207,210,211,213,216,222,224,225,226,232,237,250,269],resultset:[77,87,99,176],resultsetmetadata:156,retain:[229,267],retent:[80,229],retention_dai:[105,113],retriev:[3,7,10,17,33,51,65,73,161,214,269],retryabl:24,returntyp:31,retweet_count:14,reus:188,revers:[38,55,64,135,161],revert:[155,175,210],revoc:[3,180],revok:[3,139,267],revoke:[11,18,19,21,22,59,131,166,243,263],rewrit:[114,191,216],rewritten:[1,77,78,197,269],rfc2822:[13,14],rfc:[13,14,48,57,69],rgb:41,right:[1,43,55,68,77,78,85,101,139,149,154,179,182,186,187,222,269],rightmost:269,ring:47,ringo:42,rmi:63,rmiregistri:63,rmiserv:63,rnk:58,roadmap:191,robin:261,role:[10,73,263,267],roll:[58,131,202],rollback:[59,77,243,247],rolling_sum:58,rollup:[68,118,161,269],root:[7,18,19,21,22,30,31,33,52,73],rootgroup:2,rotat:[10,63],round:[52,133,139,183,186,261],round_robin:261,row1:7,row2:7,row3:7,row:[1,3,7,8,9,12],row_id:7,row_numb:[14,58,77,84,86,88,179,180,188,206,211,216,224],rowblock:[171,185,186],rowcount:[24,189],rownumb:14,rows:[125,131],rows_per_pag:8,rpad:[55,119],rpm:[85,99],rsa:[239,242],rtrim:[55,132,170],rule:2,run:[1,2,3,5,9,10,11,12,13,14,15,17,18,19,21,22,23,31,34,54,58,61,62],runner:3,running:5,runningsplit:1,runningtimelimit:2,runtim:[7,12],s3a:[10,77],s3n:10,s3signertyp:10,safari:111,safe:[39,57],safer:191,safeti:89,sale:[9,10,13,17,18,19,21,22,64,248,257],samaccountnam:240,same:[1,3,7,8,10,11,12,13,17,24,25,26,30,37,38,39,42,45,46,47,48,51,52,55,58,63,64,73,84,95,113,118,125,131,132,135,141,143,151,170,172,175,176,177,178,183,186,189,191,202,205,226,232,237,238,239,242,249,250,263,269],sampl:[12,14,31,37,131,141,188,205,240,269],san:[240,264,265],sasl:11,sat:45,satisfi:[237,269],satur:[1,3],saturdai:45,save:[202,265],scalar:1,scalarfunct:[31,135],scale:[24,25,26,46,61,69,178,179,182,183,185],scale_writ:178,scan:[7,9,10],scan_auth:7,scan_usernam:7,scanfilterproject:262,scanner:7,scenario:[212,240],schedulingpolici:2,schedulingweight:2,schema1:20,schema:[2,7],schema_nam:[20,248,257],schemaexist:139,schemanam:[13,14,20,24],schemanameornul:24,schemas:[18,19,21,22,23,25,26,59,130,154,185],schematablenam:[24,168],scheme:[77,240],scientist:7,scientists_idx:7,scientists_idx_metr:7,scope:[33,139,159],score:[52,71,269],scp:7,screen:105,screen_nam:14,script:[53,63,92,99,191,238,240],sdk:[10,197],search:[1,7,43,55,240],second:[2,8,9,10,13,14,38,45,47,56],secondari:[7,99],secondary:17,secondary_preferred:17,secret:[7,10,14,18,19,21,22,64,193],section:[1,5,7,10,11,13,17,45,56,57,69,73,74,238,241],secur:[6,10],securityexcept:224,see:[2,3,4,7,10,11,12,13,14,15,18,19,20,21,22,28,31,33,35,40,51,52,62,63,69,73,89,94,98,105,116,135,139,158,166,180,186,188,190,191,193,194,205,206,211,214,216,237,239,240,241,242],seek:[77,78],seen:[31,61,190,240],segment:[13,14,211,269],select:[1,2,5,7,8,9,10,11,12,13,14,16,17,18,19,20,21,22,23,38,40,42,43,44,45,48,49,50,51,52,53,58,59,61,62,68,71,84,86,99,100,102,112,131,134,142,151,157,162,176,185,188,191,192,193,196,197,202,205,206,211,216,217,225,233,237,239,243,248,249,250,251,253,255,256,260,261,262,263,264,265,267],select_expr:269,selectioncontext:184,selectioncriteria:184,self:[13,47,62,238,240],semant:[48,71,92,102,148,155,170,183,185,188,269],semaphor:194,semi:[87,93,210],semijoin:164,send:[14,176,240,241],sens:[47,73,74],sensit:[11,53,55,119,145,166,222],sent:[24,100,164,185],separ:[1,3,9,10,12,13,17,20,24,30,33,34,55,57,58,78,114,175,176,205,214,216,229,246,261],seper:73,sequenc:[13,38,55,58,73,130,132,154,161,184,185],sequencefil:10,sequencefile:210,sequenti:[2,58],serd:[191,192,202],seri:73,serializable:280,serv:[10,73,188,190,237],server:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17],serverinfo:139,servernam:22,servic:10,serviceload:33,session:[1,2,3],sessionconfigurationcontext:186,sessionproperti:11,sessionpropertyconfigurationmanag:176,sessionpropertymetadata:89,set:[1,2],set_digest:180,setcatalog:176,setdoubl:31,setlocal:202,setlong:31,setnetworktimeout:181,setnodemanag:196,setoptionalconfig:139,setproperti:64,setquerytimeout:166,setreadonli:84,setrequiredconfigurationproperti:30,sets:[118,135,161,269],setschema:176,setsessionproperti:214,setter:31,settimezoneid:202,setup:10,sever:[12,25,26,34,73,126,131,185,202,209],sf0:261,sf100000:[25,26],sf10000:[25,26],sf1000:[25,26],sf100:[25,26],sf10:25,sf1:[25,26,170,256,262,273],sf30000:[25,26],sf3000:[25,26],sf300:[25,26],sha1:[39,91],sha1prng:239,sha256:[39,91],sha512:[39,91],shadow:[134,135],shape:[14,80,88,171,211],shaprng:239,shard:[17,76,219],share:[1,47,63,102,135,168,185,229],shell:[7,17,62,63,191],ship:[35,43,100,238,241,253,269],shipmod:253,shorter:168,should:[1,2,3,4,5,7,10,11,12,13,14,16,17,20,28,33,37,41,63,73,84,96,100,133,135,176,191,193,202,205,210,211,212,213,226,227,239,240,241,242,263,267],shouldn:8,show:[2,7,12,13,14,15,18,19,20,21,22,23,25,26,59,78,89,105,110,130,148,154,159,161,164,171,176,177,180,181,183,184,185,186,188,189,190],shown:[13,41,42,48,50,191,239,269],shuffl:[9,38,139,161],shutting_down:104,side:[1,7,10,50,65,78,85,95,105,108,115,148,149,154,159,164,178,179,186,187,191,196,222,269],sign:[13,40,52,53,69,100,126,130,131,139,175,176,225,240],signatur:[10,35,186],signer:[10,139],signifi:42,signific:[3,157,191,269],significantli:[1,163,202,211,239],signum:52,silent:[11,16,105,127,139,175,176,189,226],similar:[1,3,9,30,31,33,52,53,58,73,149,166,172],similarli:130,simpl:[1,11,13,20,28,30,31,43,47,73,141,188],simpler:239,simplest:[238,240,269],simplestrategi:9,simpli:[5,7,9,10,13,17,18,19,20,21,22,24,28,31,73,196],simplifi:[7,47,63,186,211,214,269],simplify_geometri:[47,185],simul:14,simultan:[1,10],sin:52,sinc:[8,13,14,16,24,35,74,191,196,202,225,229,240,242,269],sine:52,single:[261,262],single_:61,single_bigint:61,single_varchar:61,singlemapblock:170,singlerowblock:171,singular:47,site:[10,11],situat:[11,79,239],size_estim:9,skew:[1,3,5,37,85,139,157,158,183,262],skip:[84,88,95,129,131,132,167,170,176,181,186,269],skzz0csnmd7mp4xd0yrbvx:14,slash:[13,63],sleep:14,slice:[14,31,33,38,85,119,175,226],slicearrayblock:[176,179],slide:[58,182],slightli:102,slope:37,slow:[1,8,79,168,191],slowdown:239,slower:[1,9,205],slowli:[206,226],slyli:14,small:[1,3,25,26,105,170,172,178,187,202,206,211,229,230,233],smaller:[1,42,102],smallest:[37,42,92],smallint:[10,22,48],smile_kidrauhl6:14,snappi:[61,190],snapshot:[12,73],sock:24,socket:[9,10,14],socks:[24,64,89,167,229],socksproxi:64,softcpulimit:2,softmemorylimit:2,softwar:[10,12],softwareforg:14,sole:17,solid:73,solut:[238,241],solv:241,some:[1,7,8,10,13,24,25,26,31,35,37],someth:28,sometim:[1,169,191],someus:238,soon:[85,196,222],sooner:82,sort:[1,38,52,73,77,109,132,145,177,189,269],sorted_bi:189,sorted_writing_en:189,sourc:[2,5,6,25,26,28,30,31,33,43,63,65,72],source:[2,261],span:[69,202],spanish:202,sparklin:164,spars:52,spatial:[47,184,186],special:[7,13,17,45,55,58,63,76,211],specif:[3,4,10,11,13,24,29,32,34,37,41,47,55,58,63,73,89,99,116,118,129,135,139,140,149,164,172,176,183,191,196,197,211,212,214,224,237,241],specifc:13,specifi:[1,2,5,7,8,10,11,12,13,17,22,23,24,30,31,34,37,41,42,43,45,47,48,52,53,55,56,57,58,63,64,69,76,90,92,95,99,102,108,119,126,131,134,139,149,151,157,164,173,176,178,180,181,185,189,193,202,212,219,224,237,238,239,240,241,249,253,261,263,264,267,269,273,274,276,281],specul:[9,153],speed:[1,77,206,233],spend:168,spent:[5,141,262],spi:27,spike:175,spill:0,spill_en:1,split_concurrency_adjustment_interv:115,split_count:8,split_part:55,split_to_map:[55,131,171],splitid:24,splitsourc:202,splitstatist:153,splittabl:[77,194],spnego:176,sporad:108,spuriou:[139,213],sql:[6,7,11,13,18,19,21],sqlexception:226,sqlnullabl:[31,139],sqlserver:22,sqltask:[94,214,232],sqltype:31,sqrt:52,squar:[52,211],srednekolymsk:82,sse:[10,105],ssh:11,ssl:10,sslkeystorepassword:[64,176],sslkeystorepath:[64,176],ssltruststorepassword:64,ssltruststorepath:64,st_area:47,st_astext:47,st_boundari:47,st_buffer:[47,177],st_centroid:47,st_contain:[47,180],st_convexhul:[47,189],st_coorddim:47,st_cross:[47,186],st_differ:47,st_dimens:47,st_disjoint:[47,186],st_distanc:[47,185],st_endpoint:47,st_envelop:[47,183,186],st_equal:47,st_exteriorr:47,st_geometryfromtext:47,st_geometryn:[47,189],st_geometrytyp:[47,187],st_intersect:[47,185,186],st_isclose:47,st_isempty:47,st_isring:47,st_issimpl:[47,184],st_isvalid:[47,185,189],st_length:47,st_linefromtext:47,st_numgeometri:[47,189],st_numinteriorr:47,st_numpoint:[47,189],st_overlap:[47,186],st_point:47,st_polygon:47,st_relat:47,st_startpoint:47,st_symdiffer:47,st_touch:[47,186],st_within:[47,186],st_x:47,st_xmax:[47,184],st_xmin:[47,184],st_y:47,st_ymax:[47,184],st_ymin:[47,184],stabil:[173,174,206],stack:[105,241],stage:[1,5,10],stai:3,stale:[1,179],standalon:[48,196],standard:[11,12,13,25,26,33,37,38,39,42,43,45,46,52,54,55,61,68,69],standardtyp:31,start:[2,5,7,9,10,13,14,33,38,45,47,53,55,56,58,59,63],starting:5,startup:[17,63,82,85,114,119,145,190],starvat:[1,120,168,211],stat:[24,77,87,100,108,110,112,132,135,139,143,150,154,165,171,180,205,206,216,232,262],stateless:24,statement:[2,7,18,19,21,22,42,59],statement_nam:[252,255,256,260,265],statementcli:[80,95],statementresourc:232,statementstat:132,statist:[2,5],statistics_en:164,stats:[164,171,181],statu:[23,68,84,95,139,164,171,181],std:262,stddev:[37,197],stddev_pop:37,stddev_samp:37,stderr:[14,63],stdout:[63,241],stem:55,sticki:109,still:[3,7,13,16,20,89,143,164,194,213],sting:20,stipe:184,stochast:2,stop:[38,131,196,211],stopgap:194,storag:[3,10,24,119,139,181,205],storage_format:214,store:[1,3,7,9,10,11,12,15,16,17,20,31,35,48,63,73,80,150,175,179,189,205,206,211,212,242,246,251],str_to_dat:45,straightforward:[28,48],strang:13,strategi:[13,24,28],stream:[3,37,63,77,85,95,103,120,141,172,187,211],strengh:[238,241],strength:[238,241],stress:174,strictconfig:30,strictli:2,string1:55,string2:55,string:[1,2,7,10,13,14,17,20,24,30,31,36,38,39,41,42,45,47,48,52,53],stringn:55,stringy_scientist:7,stripe:[100,132,179,184,188,189,233],strpo:[55,56],struct:[24,77,147,196,218,233],structur:24,sts:10,stsassumerolesessioncredentialsprovid:10,stssessioncredentialsprovid:10,student:[71,269],style:[10,41,173],sub:[2,7,108,123,128,185],subclass:135,subdirectori:206,subgroup:[2,184],subject:[2,69,186,205],sublist:269,submit:[1,2,11,65,73,85,100,104,177,202,216,232],subnetutil:130,suboptim:1,subproject:7,subqueri:[1,42,49,71,113,118,119,139,140,142,143,147,148,149,151,159,161,162,164,165,168,170,184,189,222],subsequ:1,subset:[3,7,13,38,65,73,150],substag:231,substanti:[1,177,193,194,211],substitut:[11,55,237],substr:[53,55,56,71,118,170,172],subtot:269,subtract:[45,52,169],succe:[196,263,267],success:[29,52,100,240],successfulli:[84,131,173,181,241],suffici:[11,31],suffix:[45,139],suggest:114,suitabl:[1,205],sum:[14,24,31,37,38,58,61,142,162,192,250,251,269],summar:[196,250,251],summari:[5,111,154,170,250],sun:45,sundai:45,superset:24,superus:[11,188],supervis:63,suppli:[25,26,41,47,149,196],supplier:14,support:[1,2],suppress:[248,249,250,257,258,259],sure:[7,9,10,13,17,18,19,20,21,22,24,126,131,211,240],surfac:47,surrog:53,surround:[47,48,53,269],swap:[3,200],symbol:[140,184],symlink:[123,129,130],symmetr:47,synchron:1,syntax:[25,26,42,45,46,53,55,57,58,59],synthet:[196,206],systemaccesscontrol:[33,34,154,237],systemaccesscontrolfactori:34,tab:102,table1:[13,20],table2:[13,20],table:[2,7,8,9,10,16,17,18,19,21,22,59,66,68,77,87,88,95,99,100,113,115,118,119,130,134,140,149,160,164,168,169,187,192,200,206,209,211,229,243,244],table_com:[249,250],table_nam:[17,20,181,182,249,250,253,254,258,263,264,267,269,273,276],table_privileg:161,tableau:[59,60],tablehandl:202,tablelayout:110,tablemetadata:24,tablenam:[13,14,20,24],tables:[12,14,15,18,19,21,22,23,59,78,154,159,161,176,185,243],tablescan:261,tablet:7,tabletserv:7,tabletserver_address:7,tag:[61,177,181],take:[1,2,7,10,11,13,31,37,38,48,69,73,88,92,102,105,142,161,162,167,168,169,178,186,189,204,206,209,239],taken:[12,123,128,239],talk:[131,210],tan:52,tangenc:47,tangent:52,tanh:52,tar:63,tarbal:[63,206,207],target:1,task_aggregation_concurr:[79,130],task_concurr:[1,130],task_default_concurr:79,task_hash_build_concurr:[79,130],task_intermediate_aggreg:[100,130],task_join_concurr:[79,130],task_share_index_load:102,task_writer_count:[1,78],taskexecutor:[1,235],tbl:7,tcge5gazngvepxu5krrvxbfkasdtea:14,tcp:10,tear:201,teardown:[76,119,196],technic:176,telnet:241,templat:2,tempor:202,temporari:[10,79,89,130,134,189,205],temporarili:155,ten:[99,206],tend:7,terabyt:74,teradata:[31,36],term:[3,45,73,155,222,263,267],termin:[9,53,62,63,95,128,182,187,224],test:[8,14,25,26,38,42],test_catalog:66,test_data:73,test_password:[66,229],test_postqueri:[66,100],test_prequeri:[66,100],test_queri:66,test_schema:66,test_usernam:[66,229],testraptordistributedqueri:206,text:[5,9,10],textfile:[10,210],textual:[13,73],tez:10,tha:52,than:[1,2,3,7,9,10,29,31,32,34,37,38,42,47,48,52,53,55,58,73,76,84,90,91,95,98,99,102,105,108,112,116,125,126,130,131,134,135,138,139,141,155,164,169,170,171,173,176,177,178,180,184,186,188,189,191,206,212,213,226,238,240,241,251,269],thei:[1,2,3,7,9,11,13,16,20,23,24,29,33,42,47,58,65,92,95,101,115,120,147,167,169,170,171,173,179,180,183,184,185,186,202,206,264,269],them:[1,2,3,8,10,11,12,17,31,33,35,48,71,104,133,155,158,175,176,202,212,214,238,241,267],themselv:[73,239],theodolit:14,therefor:[9,71],thi:[1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,37,38,39,41,42,44,45,46,47,48,52,53,54,55,56,57,58,61,62,63,64,65,69,71,73,74,76,77,78,79,81,83,85,88,89,94,95,96,98,100,102,104,105,106,108,109,110,113,116,120,126,128,131,133,134,135,139,142,145,146,147,148,149,150,152,155,158,162,164,167,168,169,170,171,173,175,176,177,178,179,180,182,183,184,185,186,187,188,189,191,192,193,194,196,200,202,203,204,205,206,209,210,211,212,213,214,216,219,225,226,227,229,230,234,237,238,239,240,241,242,243,260,269],thing:[1,14,30],think:[7,73,89],thinli:14,third:[2,73,74,201],thoroughli:7,those:[3,12,17,38,51,105,181,238,239,241,263,267,269],though:7,thought:73,thousand:[1,206,218],three:[2,9,10,11,41,58,164,237,255,269,282],thrift:[6,10],thrifthivemetastor:135,throttl:[3,97],throughout:73,throughput:[1,7,92,115,170,239],thu:[1,3,11,19,21,22,33,34,58,63,105,148,178,204,246,269],ticket:[10,241],tie:[58,212],tightli:269,tim:7,time:[1,2,3,5,7,9,10,12],timelin:[5,80,119],timeoutexecutor:1,timestamp1:45,timestamp2:45,timestamp:[7,9,10,12,13,14,24,38,42,45,56],timestamp_column:202,timestampdata:24,timestampwithtimezonetyp:35,timeuuid:9,timezon:[35,102,142,166,179,206],timezone_hour:[45,210],timezone_minut:45,timezone_minute:45,tini:[8,14,16,25,26,100,170,189,261],tinyint:[10,47,48],tion:14,tls:[17,167,176,182],tls_rsa_with_aes_128_cbc_sha256:241,tls_rsa_with_aes_128_cbc_sha:241,tmp:[238,240],tmpdir:10,to_bas:[52,76],to_base64:39,to_base64url:39,to_big_endian_64:[39,149],to_char:[56,84],to_dat:[56,84],to_hex:39,to_ieee754_32:[39,165],to_ieee754_64:[39,165],to_iso8601:[45,84],to_millisecond:[45,169],to_timestamp:[56,84],to_unixtim:45,to_utf8:[55,78],todai:7,togeth:[2,9,31,42,47,73],toggl:[77,95,102],token:[9,14,24,64,185,186],tokenawarepolici:9,toler:150,tolowercas:31,tom:37,too:[1,23,28,85,95,107,145,162,168,200,210,212,222,226,239],tool:[7,14,74],top:[5,33,63,77,86,141,197,211,237,282],topic:13,topicnam:[13,14],torn:[139,196],tostringutf8:31,total:[1,2,7,14,24,25,47,58,61,69,79,89,139,178,180,269],total_cost:43,total_pric:250,totalb:269,totalpric:[17,58,192,249,250,251,273],totals:189,tov:37,toward:3,tpc:[25,26,73,169,196],tpcd:25,tpcds:6,tpch:[6,8,14,16],tpch_:61,tpch_sf100_orc_non:61,tpch_sf100_orc_snappi:61,tpch_sf100_orc_zlib:61,tpch_sf:61,trace:[7,105,185,241],track:[1,31,73,79,100,110,113,132,163,168,177,179,180,183,197,222,249],trade:105,tradeoff:178,tradit:74,traffic:[239,244,248],trail:[46,53,55,69,145,164,170,173,183],train:205,training_data:205,transact:2,transaction:[59,243,247,268],transfer:[1,17,73,145,193,239],transform:[38,51,55,73,134,152,167],transform_kei:[51,154,168],transform_valu:[51,154,163,168],transit:202,translat:[73,187],transport:[24,31,107,135,150,154,202],treat:[3,7,13,20,40,42,47,53,55,69,77,78,105,126,131,155,177,179,183,202],tree:[30,33,37,73],tri:[17,180,240],trial:52,trigger:[104,140],trim:[55,84,132,170],tripl:7,trivial:[170,179,180,212],true_valu:43,trump:7,truncat:41,trunk:[61,66],trust:242,trustcacert:[240,242],truststor:[59,64,139,176,236,240],truststore_pass:242,trustworthi:242,truth:[42,50],try_cast:[44,139,210,230,232],tsv:61,ttl:[140,161,164],tue:14,tune:[0,1],tupl:9,tupledomain:104,ture:7,turkish:55,turn:[2,14,28,30,38,73,87,106,109,142,149,164,179,180,185,202,216,219],tutori:6,twice:78,twistr:14,twistr_kafka_0811:14,twitter_fe:14,two:[1,5,7,9,10,11,12,13,18,19,21,22,31,35,38,43,45,47,51,55,61,66,69,71,73,77,95,125,131,139,155,171,186,193,196,206,211,212,237,238,239,240,241,242,260,269,282],two_1:51,type:[1,2,7],typemanag:135,typeparamet:31,typic:[7,10,17,57,63,114,187,202,216,238,241],ud800:53,udc00:53,udt:9,uescape:68,uid:240,unaccept:241,unacknowledged:17,unauthent:241,unauthor:11,unbalanc:196,unbias:37,unbound:[125,131],unbounded:[24,58,125,131],uncommitted:280,uncommon:10,uncompact:13,uncorrel:[134,140],undefin:[16,42],under:[11,15,74,83,168,170,174,182,206,214,237],underestim:161,underli:[1,9,28,31,73,77,139,147,186,214,269],underscor:[53,104,196,211,232],understand:[7,30,33,73,74,77,262],underutil:1,unencrypt:166,unescap:57,uneven:38,unexpect:[92,116,202],unfortun:[17,191],unframed:24,unicod:53,unimpl:226,uniqu:[5,24,58,63,185,202,239,269],unit:[25,45,47,52,55,78,164,202,239,242],unix:[8,35,45,62],unixtim:45,unknown:[42,51,113,167,173,185,226,239,242,255],unless:[2,164,192,214,269],unlik:[31,71],unnecessari:[141,161,164,177,183,184],unnecessarili:116,unnest:68,unord:73,unpack:63,unparenthes:226,unpartit:[102,131,192],unqualifi:[13,20,242],unreach:80,unrecover:[130,202],unreferenc:234,unresolv:108,unsecur:11,unsent:9,unset:184,unstructur:14,unsupportedoperationexcept:226,until:43,unus:[188,206,207],unwind:14,unwrap:214,upcom:169,update:[7,14,131,139,155,166,216,226,230,238,241,281],upgrad:[63,100,202,229],upgrade:[80,190],upload:10,upon:73,upper:[24,37,52,53,55,83,108,139,197],uppercas:[55,57,118,147],upstream:1,uptim:[12,164],urandom:239,uri:[10,30,57,63,176,190,239],url:[10,18,19,21,22,36,39],url_decod:[57,89,135],url_encod:[57,89],url_extract_frag:57,url_extract_host:57,url_extract_paramet:57,url_extract_path:57,url_extract_port:57,url_extract_protocol:57,url_extract_queri:57,usag:[1,2,3,7,48,77,79,80,104,105,111,113,131,141,143,144,145,154,159,165,166,168,170,171,172,173,176,178,181,183,185,186,188,189,202,205,240,241],use:[1,9,10],use_mark_distinct:185,useg1gc:63,usegcoverheadlimit:63,useless:105,user:[1,2,7,9,10],user_ag:10,user_id:[9,10,245],user_nam:14,usernam:[5,7,9],using:[1,7,9],usual:[1,7,17,31,170],utc:[24,45,131,184],utf8slic:31,utf:[13,24,55,56,57,78,132,183,187],util:[1,7,14,30,31,162,171,179,185,239],uuid:[9,10,84,190],valid:[7,30,32,47,55,57,64,76,78,85,89,102,113,139,145,154,158,162,164,167,176,179,182,183,184,185,188,210,222,240,261],validate:[151,261],validation_data:205,valu:[1,2,3,7,8,9,10,11,12,13],value1:[29,31,32,34,42,43,48],value2:[29,31,32,34,42,43,48],value3:48,valuen:42,values:[7,17,42,59,68,78,142,180,197,206,226,233,243,264,265,269],valueset:24,valuewindowfunct:135,var_pop:37,var_samp:37,varbinari:[37,39,55,69,149,161,182,205,211,229,230],varbinary:9,varchar:[7,8,9,10,13,14,17,20,22,24,31,35,38,39,41,42,44,45,47,48,51,52,53,54,55,56,57,66],varchardata:24,varchartyp:35,vari:[10,26,41,45,238,239,241],variablewidthblockencod:234,varianc:[37,197],variance:197,variant:[9,37,105,108,142,183,184,185],varieti:73,variou:[5,7,20,30,31,33,64,108,134,141,165,168],vast:74,vector:[52,114,216],verbos:[63,216],verbose:[168,262],veri:[1,12,25,26,30,63,120,149,179,196,233],verifi:[11,14,34,59,60],verifiableproperti:14,verifier_queri:[66,100,229],versa:44,version:[7,9,12,14,33,47,63,64,77,78,95,102,108,126,131,139,142,143,154,155,164,166,194,196,200,210,223,226,238,240,241],via:[1,2,5,7,8,9,10,12,23,30,31,32],vice:44,view:[2,18,19,21,22,59,71,77,92,95,106,113,128,130,135,139,145,151,164,172,179,184,186],view_nam:[251,259,274],view_tim:10,viewf:179,viewfilesystem:154,violat:164,virtual:[10,12,63],visibl:[22,23,55,78,154],visual:[5,80,112,119,200,216],vmname:12,vmversion:12,wai:[8,17,42,61,73,100,149,205,237,238,239,240],wait:[1,5,9],wake:14,wall:[61,79,114,139,216,262],walltimemean:61,walltimep50:61,walltimestd:61,want:[1,7,19,21,22,31,65,71,192,237,238,239,240,241,262],wareh:74,warehous:[10,11,216],warm:61,warn:[63,131],wast:[1,147],web:0,week:45,week_of_year:45,weekdai:45,weigh:37,weight:[2,37,184],weighted_fair:[176,179,185],weird:193,well:[1,4,7,10,20,47,179,262,263,267],were:[1,13,16,20,23,24,79,88,95,123,126,128,131,132,135,155,171,176,180,184,185,187,191,196,198,211,212,220,226],what:[7,31,33,73],when:[1,2,3,7,8,9,10,11,12,13,16,17,20,23,24,25,26,28,31,33,34,37,38,42,43,44,45,46,48,53,63,64,65,68,69],whenev:[33,193],where:[1,3,5,7,10,14,15,17,23,31,43,45,57,58,68,69,71,84,86,89,91,93,97,99,100,101,102,112,118,123,128,131,134,139,142,147,151,158,160,161,163,165,167,170,172,176,180,183,184,185,191,202,211,213,216,219,220,222,223,225,226,233,240,241,253,255,260,261,262,265,269,280,282],wherea:[1,71],whether:[11,13,17,20,34,42,102,183,202,237,269],which:[1,2,5,7,10,11,12,13,14,17,20,24,25,26,28,29,30,31,32,33,34,35,37,38,41,42,47,51,55,58,61,62,63,69,71,73,77,78,79,80,81,85,89,91,99,100,102,105,108,109,112,114,115,116,121,128,129,131,133,134,135,136,139,140,145,150,154,155,157,161,162,165,166,167,168,170,176,177,178,179,185,190,194,196,202,206,210,211,212,213,214,215,216,222,226,237,238,239,240,241,249,262,269],white:[9,41],whitelist:[24,139],whitelistpolici:9,whitespac:55,who:[9,11,23,34],whole:3,whose:[47,143,214,220,256],why:[47,73,269],wide:69,widen:10,width:[13,41,52,95],width_bucket:[52,119],wildcard:[12,185,239],wilson:52,wilson_interval_low:[52,189],wilson_interval_upp:[52,189],window:[1,36],windowfunct:135,wise:38,wish:[7,10,63],with_queri:269,within:[2,3,7,11,12,13,14,17,19,20,21,22,37,41,42,47,53,58,69,73,76,102,162,172,206,239,269],without:[9,10,13,14,20,24,25,26,30,31,35,38,43,48,53,61,69,81,91,95,135,167,176,191,192,194,196,206,212,216,264,282],wjalrxutnfemi:193,wkt:[47,179],word:[53,55],word_stem:[55,181],work:[1,4,7,8,10,11,14,16,30,31,42,46,63,73,74,76,79,89,94,130,170,172,180,191,193,196,202],worker1:239,worker2:239,workload:[4,74,177,196],world:42,wors:213,would:[11,33,34,58,63,66,73,95,102,104,113,125,131,139,140,150,169,170,173,175,179,180,184,191,196,204,205,206,211,220,225,229,230,237],wrap:[29,32,34],wrapper:[7,31,238,240],writedoubl:31,writeobject:186,writepositionto:186,writer_min_s:178,written:[1,3,8,9,10,15,24,49,63,77,81,89,95,110,116,134,135,139,142,170,173,177,178,179,180,183,189,191,192,196,203,205,211,225,226,234],wrong:[102,126,131,134,148,170,180,187,191,204,223],x00:7,x00g:7,x00m:7,x06:7,x08:7,x500:176,x500princip:176,x7f:7,x80:7,x_i:37,xa6:7,xad:7,xed:7,xff:7,xkiaftjuscuxfelenqefumtrjs:14,xml:[10,11,33],xmx16g:63,xor:40,xstf4:14,xxhash64:[39,149,150],xxvsjslagtn:14,xxx:7,xxxxxxx:46,yael:37,year:[38,45,56],year_of_week:[45,226],yellow:41,yet:[1,7,10,14,18,19,21,22,45,69,110,176,182,189,194],yield:186,york:[53,269],you:[1,3,4,7,8,9,10,11,12,13,15,17,18,19,20,21,22,23,24,25,26,28,30,31,33,35,42,53,63,65,66,71,73,74,77,81,89,92,94,95,99,100,110,114,116,133,134,135,139,142,173,177,182,191,192,196,202,203,205,211,212,214,216,225,226,229,234,237,238,239,240,241,242,262,269],younger:7,your:[4,7,9,10,11,14,17,18,19,21,22,28,64,65,77,81,89,92,95,100,105,110,113,116,133,134,135,139,142,173,177,182,191,192,193,196,203,205,206,210,211,216,225,226,229,234,237,238,239,240,241,242],yow:45,yvn:14,yyyi:56,yyyyyyi:46,z123:53,zero:[8,9,11,24,37,43,46,48,58,77,84,89,95,181,184,187,196,197,269],zip:[38,131,185,238,241,245],zip_with:[38,154],zkcli:7,zlib:61,znode:7,zone:42,zookeep:[7,14],zookeepermetadatamanag:7,zoom:47,zoom_level:47,zset:20,zstandard:182},titles:["4. Administration","4.3. Properties Reference","4.5. Resource Groups","4.4. Spill to Disk","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. Memory Connector","5.11. MongoDB Connector","5.12. MySQL Connector","5.13. PostgreSQL Connector","5.14. Redis Connector","5.15. Redshift Connector","5.16. SQL Server Connector","5.17. System Connector","5.18. Thrift Connector","5.19. TPCDS Connector","5.20. TPCH Connector","10. Developer Guide","10.2. Connectors","10.8. Event Listener","10.3. Example HTTP Connector","10.5. Functions","10.7. Password Authenticator","10.1. SPI Overview","10.6. System Access Control","10.4. Types","6. Functions and Operators","6.14. Aggregate Functions","6.16. Array Functions and Operators","6.11. Binary Functions and Operators","6.7. Bitwise Functions","6.20. Color Functions","6.2. Comparison Functions and Operators","6.3. Conditional Expressions","6.5. Conversion Functions","6.13. Date and Time Functions and Operators","6.8. Decimal Functions and Operators","6.19. Geospatial Functions","6.12. JSON Functions and Operators","6.4. Lambda Expressions","6.1. Logical Operators","6.17. Map Functions and Operators","6.6. Mathematical Functions and Operators","6.10. Regular Expression Functions","6.21. Session Information","6.9. String Functions and Operators","6.22. Teradata Functions","6.18. 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.2. Reserved Keywords","7.1. Data Types","9. Migration","9.1. Migrating From Hive","1. Overview","1.2. Presto Concepts","1.1. Use Cases","11. Release Notes","11.114. Release 0.100","11.113. Release 0.101","11.112. Release 0.102","11.111. Release 0.103","11.110. Release 0.104","11.109. Release 0.105","11.108. Release 0.106","11.107. Release 0.107","11.106. Release 0.108","11.105. Release 0.109","11.104. Release 0.110","11.103. Release 0.111","11.102. Release 0.112","11.101. Release 0.113","11.100. Release 0.114","11.99. Release 0.115","11.98. Release 0.116","11.97. Release 0.117","11.96. Release 0.118","11.95. Release 0.119","11.94. Release 0.120","11.93. Release 0.121","11.92. Release 0.122","11.91. Release 0.123","11.90. Release 0.124","11.89. Release 0.125","11.88. Release 0.126","11.87. Release 0.127","11.86. Release 0.128","11.85. Release 0.129","11.84. Release 0.130","11.83. Release 0.131","11.82. Release 0.132","11.81. Release 0.133","11.80. Release 0.134","11.79. Release 0.135","11.78. Release 0.136","11.77. Release 0.137","11.76. Release 0.138","11.75. Release 0.139","11.74. Release 0.140","11.73. Release 0.141","11.72. Release 0.142","11.71. Release 0.143","11.70. Release 0.144","11.69. Release 0.144.1","11.68. Release 0.144.2","11.67. Release 0.144.3","11.66. Release 0.144.4","11.65. Release 0.144.5","11.64. Release 0.144.6","11.63. Release 0.144.7","11.62. Release 0.145","11.61. Release 0.146","11.60. Release 0.147","11.59. Release 0.148","11.58. Release 0.149","11.57. Release 0.150","11.56. Release 0.151","11.55. Release 0.152","11.54. Release 0.152.1","11.53. Release 0.152.2","11.52. Release 0.152.3","11.51. Release 0.153","11.50. Release 0.154","11.49. Release 0.155","11.48. Release 0.156","11.47. Release 0.157","11.46. Release 0.157.1","11.45. Release 0.158","11.44. Release 0.159","11.43. Release 0.160","11.42. Release 0.161","11.41. Release 0.162","11.40. Release 0.163","11.39. Release 0.164","11.38. Release 0.165","11.37. Release 0.166","11.36. Release 0.167","11.35. Release 0.168","11.34. Release 0.169","11.33. Release 0.170","11.32. Release 0.171","11.31. Release 0.172","11.30. Release 0.173","11.29. Release 0.174","11.28. Release 0.175","11.27. Release 0.176","11.26. Release 0.177","11.25. Release 0.178","11.24. Release 0.179","11.23. Release 0.180","11.22. Release 0.181","11.21. Release 0.182","11.20. Release 0.183","11.19. Release 0.184","11.18. Release 0.185","11.17. Release 0.186","11.16. Release 0.187","11.15. Release 0.188","11.14. Release 0.189","11.13. Release 0.190","11.12. Release 0.191","11.11. Release 0.192","11.10. Release 0.193","11.9. Release 0.194","11.8. Release 0.195","11.7. Release 0.196","11.6. Release 0.197","11.5. Release 0.198","11.4. Release 0.199","11.3. Release 0.200","11.2. Release 0.201","11.1. Release 0.202","11.160. Release 0.54","11.159. Release 0.55","11.158. Release 0.56","11.157. Release 0.57","11.156. Release 0.58","11.155. Release 0.59","11.154. Release 0.60","11.153. Release 0.61","11.152. Release 0.62","11.151. Release 0.63","11.150. Release 0.64","11.149. Release 0.65","11.148. Release 0.66","11.147. Release 0.67","11.146. Release 0.68","11.145. Release 0.69","11.144. Release 0.70","11.143. Release 0.71","11.142. Release 0.72","11.141. Release 0.73","11.140. Release 0.74","11.139. Release 0.75","11.138. Release 0.76","11.137. Release 0.77","11.136. Release 0.78","11.135. Release 0.79","11.134. Release 0.80","11.133. Release 0.81","11.132. Release 0.82","11.131. Release 0.83","11.130. Release 0.84","11.129. Release 0.85","11.128. Release 0.86","11.127. Release 0.87","11.126. Release 0.88","11.125. Release 0.89","11.124. Release 0.90","11.123. Release 0.91","11.122. Release 0.92","11.121. Release 0.93","11.120. Release 0.94","11.119. Release 0.95","11.118. Release 0.96","11.117. Release 0.97","11.116. Release 0.98","11.115. Release 0.99","3. Security","3.5. Built-in System Access Control","3.2. CLI Kerberos Authentication","3.6. Secure Internal Communication","3.3. LDAP Authentication","3.1. Coordinator Kerberos Authentication","3.4. Java Keystores and Truststores","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. DEALLOCATE PREPARE","8.10. DELETE","8.11. DESCRIBE","8.12. DESCRIBE INPUT","8.13. DESCRIBE OUTPUT","8.14. DROP SCHEMA","8.15. DROP TABLE","8.16. DROP VIEW","8.17. EXECUTE","8.18. EXPLAIN","8.19. EXPLAIN ANALYZE","8.20. GRANT","8.21. INSERT","8.22. PREPARE","8.23. RESET SESSION","8.24. REVOKE","8.25. ROLLBACK","8.26. SELECT","8.27. SET SESSION","8.28. SHOW CATALOGS","8.29. SHOW COLUMNS","8.30. SHOW CREATE TABLE","8.31. SHOW CREATE VIEW","8.32. SHOW FUNCTIONS","8.33. SHOW GRANTS","8.34. SHOW SCHEMAS","8.35. SHOW SESSION","8.36. SHOW TABLES","8.37. START TRANSACTION","8.38. USE","8.39. VALUES"],titleterms:{"boolean":69,"case":[43,74],"char":69,"default":[13,20],"delete":253,"double":69,"float":[52,69],"function":[1,31,36,37,38,39,40,41,42,44,45,46,47,48,51,52,53,55,56,57,58,78,131,139,191,196,205,206,211,226],"new":[114,216],"null":[42,50],"try":43,_default:13,about:11,access:[10,11,34,71,237,241],accessor:47,accumulo:[7,150,163,168,177],active:240,add:[14,197],adding:7,addition:[11,238,241],address:[24,69],administr:0,advanc:239,aggreg:1,aggregat:[3,31,37,58,191,193],aliv:17,all:[14,42,237],allow:237,also:[244,245,247,248,249,250,251,252,255,256,257,258,259,260,261,262,263,264,265,266,267,268,270,273,274,276,278,280,282],alter:[244,245],altern:240,amazon:[10,193,197],analyze:262,another:31,ansi:71,any:42,apach:14,approxim:37,argument:61,arithmet:46,arrai:[38,71,234],array:[69,214],authent:[10,11,32,238,240,241],author:[11,94,240],avoid:71,aware:105,base:[11,237,240],basic:14,batch:17,benchmark:61,between:[42,92],big:[85,216],bigint:69,binari:[39,46,191,205],bing:47,bitwis:[37,40],black:[8,129],blackhol:[139,180],bound:71,bucket:191,buffer:[1,13],bug:[196,202],build:33,built:237,bytecod:210,call:246,candid:1,cassandra:[9,84,95,129,131,145,150,153,154,155,156,157,164,167,181,197,202,209,212,216],cast:[48,71,92],catalog:[23,63,73,196,237],catalogs:271,cert:240,certificateexcept:240,chang:[76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,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,178,179,180,181,182,183,184,185,186,187,188,189,196,202,203,205,206,209,210,211,212,213,214,215,216,217,219,222,223,224,225,226,227,228,229,230,231,232,233,234,235],claus:269,cli:[61,95,105,108,128,139,156,164,167,169,175,177,178,179,180,181,182,184,185,189,191,238,240],client:[1,11,24],cluster:[9,10,13,17,21,79,89,92],coalesce:43,code:[30,33],collect:17,color:41,column:[7,13,14,20,269],columns:272,command:62,commit:247,common:240,commun:239,comparison:[42,46],compat:9,compil:210,complex:71,compound:196,concaten:[38,71],concept:73,concern:17,concurr:[1,115],condit:43,config:[4,63,240,241],configur:[7,8,9,10,11,12,13,15,16,17,18,19,20,21,22,23,24,25,26,29,32,34,63,205,238,239,240,241],connect:[13,17,64],connector:[6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,28,30,65,73,76,131,148,165,172,176,177,178,180,186,196,205,206,212,214],connectorfactori:[28,30],connectormetadata:28,connectorrecordsetprovid:28,connectorsplitmang:28,constructor:[47,197],control:[34,237,241],conveni:45,convers:[44,45],convert:7,coordin:[73,205,240,241],count:[1,20],cpu:191,creat:14,create:[248,249,250,251,273,274],creation:192,credenti:[10,17],cross:[192,269],cryptographi:[238,241],csv:13,cursor:17,custom:[10,33],data:[7,9,10,14,69,73],databas:[19,20,21,22],datasourc:205,date:[13,45,56,69,202,225],day:69,deallocate:252,debug:[238,240,241],decim:46,decimal:69,decod:13,definit:[13,17,20],delimit:20,depend:7,deploi:[33,63],describe:[254,255,256],descript:[13,14,20,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282],develop:27,dfa:1,dictionari:1,dir:[13,20],directori:240,disk:3,distinct:[1,42,191,193,196],distribut:[1,191,213],divid:71,document:59,driver:[1,61,64,73,105,135,139,154,155,156,157,166,167,168,171,173,175,176,177,180,181,186],drop:[257,258,259],dual:206,durat:45,dynam:[71,115],effect:50,efficienc:191,enabl:[1,11,17,239],encode:57,encryption:10,end:11,environ:[238,240,241],epilogu:14,error:240,event:29,evolut:10,exampl:[8,10,11,16,30,31,43,244,245,246,247,248,249,250,251,252,253,255,256,257,258,259,260,261,262,263,264,265,266,267,268,270,273,276,280,281,282],exampleconnector:30,examplemetadata:30,examplerecordsetprovid:30,examplesplitmanag:30,except:269,exchang:[1,73],execut:[73,238,240],execute:260,exists:269,expand:71,experiment:1,explain:[261,262],express:71,expression:[1,43,49,53,78],extension:[238,241],external:7,extraction:[45,57],featur:[7,131,139,226],feed:14,field:13,file:[10,11,13,14,15,20,24,135,237,238,240,241,242],filter:196,fix:[69,131,191,196,202],format:210,from:[7,14,42,48,71,191],functions:275,gain:191,gener:[1,37,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,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,178,179,180,181,182,183,184,185,186,187,188,189,202,205,206,209,210,211,212,213,214,215,216,217,219,222,223,224,225,226,227,228,229,230,231,232,233,234,235],geospati:47,global:2,grace:104,grant:263,grants:276,greatest:42,group:[2,139,173,175,176,177,178,184,185,240,269],guid:27,hadoop:[10,11,193],hash:[1,191],having:269,hdf:11,hdfs:[10,11],hide:[13,20],hive:[10,11,71,77,78,79,80,88,89,90,91,95,99,100,102,105,108,110,113,114,115,116,118,119,120,121,123,128,129,130,131,132,133,135,137,139,140,141,142,143,145,146,147,148,149,150,151,152,153,154,155,157,158,161,162,164,165,166,167,168,169,170,171,172,173,176,177,178,179,180,181,182,183,184,185,186,187,188,189,191,202,206,210,211,212,213,214,215,216,217,226,232,233,234],hole:[8,129],host:17,http:[1,30],http_request_log:15,identifi:71,idl:24,imperson:11,implement:[29,30,31,32,34],improv:196,improvement:[92,206],index:[7,20,71,213],info:1,informat:[11,54,238,241],input:255,insert:264,install:[7,14,63],installat:[14,60],instead:71,integ:71,integer:69,interfac:[5,62],intern:[13,20],internal:[7,13,20,239],intersect:269,interv:1,interval:[45,69,131],introduct:14,ipaddress:69,iterat:7,java:[45,238,240,241,242],jdbc:[64,105,135,139,154,155,156,157,166,167,168,171,173,175,176,177,180,181,182,186,196],jmx:[12,131,139,148,179,185],join:[1,3,192,213,269],json:[13,48,69,92,211],json_array_get:191,jvm:[4,63],kafka:[13,14,130,131,176,182,212,213],keep:17,kei:[13,20],kerbero:[10,11,238,241],kerberos:11,keystor:[238,240,241,242],keytab:[11,238,241],keyword:[68,191],known:14,lambda:49,languag:[67,131,139,226],ldap:240,learn:[205,206],least:42,length:205,level:63,librari:1,limit:[1,9,10,16,18,19,21,22,196,253,263,267,269,276],line:62,listen:29,liter:46,live:14,load:[7,14],local:[15,135,202],log:63,logic:50,machin:[205,206],make:14,manag:[3,7,30,79,89,92],map:[14,37,51,69,71,214,234],mathemat:52,maven:33,max:[1,17,24],membership:240,memori:[1,3,16,92,165,172,180,229,230],messag:[13,14],metadata:[1,7,23,24,30,33,216],metastor:11,migrat:[70,71],min:[1,17],miscellan:[44,193,197],mit:[238,241],model:73,mongodb:[17,150,155,162,163,179,180,182],month:69,multipl:[9,10,13,17,18,19,20,21,22,24],multipli:1,mysql:[18,45,95,104,130,131,135,139,152,163,176,178,179,182,187,212],name:[13,20,240,269],network:[1,69,105],node:[1,13,20,23,63,240,241],non:191,none:11,note:75,nullif:43,number:[13,71,211],objectid:17,only:[216,237],onto:14,openldap:240,oper:[1,71],operat:[3,36,38,39,42,45,46,47,48,50,51,52,55,73],optim:1,optimiz:[1,196,202,211,216],option:191,orc:[216,229,230],order:269,other:131,out:71,output:[61,256],overview:[3,7,10,13,33,72,73],parallel:79,paramet:64,parametr:[31,213],parquet:114,partial:1,password:[20,32,240],path:1,pend:1,per:[1,17],perform:239,pluggabl:139,plugin:[30,31,33,209,241],point:[52,69],polici:[238,241],postgresql:[19,95,130,131,135,139,152,168,176,178,179,212],precis:69,predic:[42,191,196],prefer:17,prefix:20,prepare:[252,265],present:240,presto:[4,11,14,24,59,63,66,73,74,206,238,240,241],prevent:205,princip:[11,237,238,241],procedur:23,properti:[1,2,4,7,9,10,11,13,15,17,20,24,63,89,99,214,240,241],protect:10,provid:[10,30],push:1,pushdown:191,qualifi:269,quantifi:42,queri:[1,9,12,14,18,19,21,22,23,61,71,73,85,216],quot:71,rang:[42,191,196],rank:58,raptor:[205,219],raw:13,re2j:1,read:[17,237],reader:[114,216],real:69,record:30,redi:[20,130,142,182],redistribut:1,redshift:[21,176,178],refer:[1,64],refresh:24,regex:1,regular:[1,53,78],relationship:47,releas:[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,178,179,180,181,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,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235],remov:85,replica:17,request:1,requir:17,reserv:[1,68,191],reset:266,resourc:[1,2,79,89,139,173,175,176,177,178,184,185,241],respons:[1,24],retri:1,revoke:267,rollback:268,row:[13,69,211,234],rpm:186,rule:[11,237],run:63,runtim:23,scalar:[31,269],scan:20,schedul:[1,105,205,211],schema:[10,11,13,15,17,20,25,26,73,196,244,248,257],schema_properti:23,schemas:[191,277],second:69,secur:[11,154,176,180,182,183,186,188,236,239,240],see:[244,245,247,248,249,250,251,252,255,256,257,258,259,260,261,262,263,264,265,266,267,268,270,273,274,276,278,280,282],seed:17,select:269,selector:2,serial:7,server:[18,19,20,22,73,176,178,186,240],servic:[11,238,241],session:[7,11,54,89,214,266,270,278],set:[4,17,30,270],setup:14,show:[191,271,272,273,274,275,276,277,278,279],shutdown:104,simpl:191,singl:1,sink:1,size:[1,13,17,24],smallint:69,socket:17,some:42,sourc:[73,191],space:[1,3],spi:[33,77,81,89,95,110,116,134,135,139,141,142,149,153,154,155,161,165,166,167,168,170,171,173,175,176,177,179,184,185,186,188,189,196,202,203,211,226,234],spill:[1,3],spiller:1,split:[1,30,73,115],sql:[22,67,71,176,178,243],ssl:[17,239,240],stage:73,stamp:14,standard:71,start:[71,280],state:1,statement:[73,243],statist:[37,52],step:14,storag:210,stream:213,string:[55,56,69,71],structur:69,subject:240,subqueri:269,subscript:[38,51,71],suit:61,support:[3,10,11,78,85,197,216],synopsi:[244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282],syntax:[71,243],system:[1,23,24,34,76,202,237,241],tabl:[1,7,9,11,13,14,15,17,20,23,73,99,191,192,197,206],table:[245,249,250,258,273],table_properti:23,tableau:65,tables:279,tablesample:269,target:71,task:[1,23,73,79],teradata:56,test:47,text:13,thread:[1,24],threshold:1,thrift:[11,24,176,177,178,186],through:1,tile:47,time:[13,14,17,45,69,202],timeout:[1,13,17],timestamp:69,tinyint:69,tls:[238,239,240,241,242],topic:14,topolog:[1,105],tpcds:[25,170,171],tpch:[26,170,196],transact:23,transaction:280,trigonometr:52,troubleshoot:[238,240,241,242],truncat:45,truststor:242,tune:[4,10,239],tutori:14,tweet:14,twitter:14,type:[9,10,11,35,69,71,73,202,205,213,214,225,234],udf:71,unari:46,unicod:[55,78],union:[1,269],unnest:[71,269],unspil:1,unsupport:7,updat:1,url:57,usage:[7,229,230],use:[14,71,74,196,281],user:11,usernam:10,using:23,valu:[14,58,197],values:282,varbinary:69,varchar:[69,92],variabl:[7,205],verif:[240,241,242],verifi:[66,95,100,128,131,134,135,157,206,229],via:33,view:[206,251,259,274],wait:17,web:[5,65,77,139,151,154,157,158,161,164,170,171,179,181],what:74,when:71,who:74,window:[58,196],work:205,worker:[1,73],write:[1,17],writer:1,year:69,zone:[45,69,202]}})