sankarh 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_r275609707
########## 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: Updated test script as per your comment. Pls check. ---------------------------------------------------------------- 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
