jcamachor commented on a change in pull request #597: HIVE-21564: Load data into a bucketed table is ignoring partitions specs and loads data into default partition. URL: https://github.com/apache/hive/pull/597#discussion_r275569226
########## File path: ql/src/test/queries/clientpositive/load_static_ptn_into_bucketed_table.q ########## @@ -0,0 +1,33 @@ +set hive.stats.column.autogather=false; +set hive.strict.checks.bucketing=true; + +set hive.explain.user=false; + +-- SORT_QUERY_RESULTS + +-- Single key partition +-- Load with full partition spec +CREATE TABLE src_bucket_tbl(key int, value string) partitioned by (ds string) clustered by (key) into 1 buckets STORED AS TEXTFILE; +explain load data local inpath '../../data/files/bmj/000000_0' INTO TABLE src_bucket_tbl partition(ds='2008-04-08'); +load data local inpath '../../data/files/bmj/000000_0' INTO TABLE src_bucket_tbl partition(ds='2008-04-08'); +select * from src_bucket_tbl where ds='2008-04-08'; + +drop table src_bucket_tbl; + +-- Multi key partition +-- Load with both static and dynamic partition spec +CREATE TABLE src_bucket_tbl(key int, value string) partitioned by (hr int, ds string) clustered by (key) into 1 buckets STORED AS TEXTFILE; Review comment: Can we add another load test with multi-key static + dynamic partitioning, but with dynamic value taken from file instead of just null and ending in default partition? I believe ```load_data_1_partition.txt``` can be used for that purpose. Can you also invert partitioned keys (first static, second dynamic) in any of the tests? ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For additional commands, e-mail: gitbox-h...@hive.apache.org
