[ https://issues.apache.org/jira/browse/CARBONDATA-2060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Manish Gupta resolved CARBONDATA-2060. -------------------------------------- Resolution: Fixed Fix Version/s: 1.3.0 > Fix InsertOverwrite on partition table > -------------------------------------- > > Key: CARBONDATA-2060 > URL: https://issues.apache.org/jira/browse/CARBONDATA-2060 > Project: CarbonData > Issue Type: Bug > Reporter: Akash R Nilugal > Assignee: Akash R Nilugal > Priority: Minor > Fix For: 1.3.0 > > Time Spent: 3h > Remaining Estimate: 0h > > {color:#333333}when partition table overwrite with empty table , it is not > overwriting the partition table , and when insert overwrite is done on > dynamic partition table , overwrite was not happening.{color} > > {color:#333333}sql("create table partitionLoadTable(name string, age int) > PARTITIONED BY(address string) stored by 'carbondata'"){color} > {color:#333333}sql("insert into partitionLoadTable select > 'abc',4,'def'"){color} > {color:#333333}sql("insert into partitionLoadTable select > 'abd',5,'xyz'"){color} > {color:#333333}sql("create table noLoadTable (name string, age int, address > string) stored by 'carbondata'"){color} > {color:#333333}sql("insert overwrite table partitionLoadTable select * from > noLoadTable"){color} > {color:#333333}when we do select * after insert overwrite operation, ideally > it should give empty data, but it is giving all data.{color} > > {color:#333333}sql("CREATE TABLE uniqdata_hive_static (CUST_ID int,CUST_NAME > String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, > BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), > DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double, > INTEGER_COLUMN1 int)ROW FORMAT DELIMITED FIELDS TERMINATED BY ','"){color} > {color:#333333}sql("CREATE TABLE uniqdata_string_static(CUST_ID int,CUST_NAME > String,DOB timestamp,DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 > bigint,DECIMAL_COLUMN1 decimal(30,10),DECIMAL_COLUMN2 > decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 > int) PARTITIONED BY(ACTIVE_EMUI_VERSION string) STORED BY > 'org.apache.carbondata.format' TBLPROPERTIES ('TABLE_BLOCKSIZE'= '256 > MB')"){color} > {color:#333333}sql(s"LOAD DATA INPATH '$resourcesPath/partData.csv' into > table uniqdata_string_static OPTIONS('FILEHEADER'='CUST_ID,CUST_NAME > ,ACTIVE_EMUI_VERSION,DOB,DOJ, > BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1, > Double_COLUMN2,INTEGER_COLUMN1','BAD_RECORDS_ACTION'='FORCE')"){color} > {color:#333333}sql(s"LOAD DATA INPATH '$resourcesPath/partData.csv' into > table uniqdata_string_static OPTIONS('FILEHEADER'='CUST_ID,CUST_NAME > ,ACTIVE_EMUI_VERSION,DOB,DOJ, > BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1, > Double_COLUMN2,INTEGER_COLUMN1','BAD_RECORDS_ACTION'='FORCE')"){color} > {color:#333333}sql("insert overwrite table uniqdata_string_static select > CUST_ID, CUST_NAME,DOB,doj, bigint_column1, bigint_column2, decimal_column1, > decimal_column2,double_column1, > double_column2,integer_column1,active_emui_version from uniqdata_hive_static > limit 10"){color} > > {color:#333333}after this, select * was giving result, ideally it should give > empty result.{color} > -- This message was sent by Atlassian JIRA (v7.6.3#76005)