[ https://issues.apache.org/jira/browse/CARBONDATA-1731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
anubhav tarar reassigned CARBONDATA-1731: ----------------------------------------- Assignee: anubhav tarar > Carbon1.3.0- DB creation external path: Update fails incorrectly with error > for table created in external db location > --------------------------------------------------------------------------------------------------------------------- > > Key: CARBONDATA-1731 > URL: https://issues.apache.org/jira/browse/CARBONDATA-1731 > Project: CarbonData > Issue Type: Bug > Components: data-load > Affects Versions: 1.3.0 > Environment: 3 node ant cluster > Reporter: Chetan Bhat > Assignee: anubhav tarar > Labels: DFX > Time Spent: 10m > Remaining Estimate: 0h > > Steps : > 0: jdbc:hive2://10.18.98.34:23040> drop database if exists test_db1 cascade; > +---------+--+ > | Result | > +---------+--+ > +---------+--+ > No rows selected (0.279 seconds) > 0: jdbc:hive2://10.18.98.34:23040> create database test_db1 location > 'hdfs://hacluster/user/test1'; > +---------+--+ > | Result | > +---------+--+ > +---------+--+ > No rows selected (0.04 seconds) > 0: jdbc:hive2://10.18.98.34:23040> use test_db1; > +---------+--+ > | Result | > +---------+--+ > +---------+--+ > No rows selected (0.011 seconds) > 0: jdbc:hive2://10.18.98.34:23040> create table if not exists > ORDERS(O_ORDERDATE string,O_ORDERPRIORITY string,O_ORDERSTATUS > string,O_ORDERKEY string,O_CUSTKEY string,O_TOTALPRICE double,O_CLERK > string,O_SHIPPRIORITY int,O_COMMENT string) STORED BY > 'org.apache.carbondata.format' TBLPROPERTIES ('table_blocksize'='128'); > +---------+--+ > | Result | > +---------+--+ > +---------+--+ > No rows selected (0.15 seconds) > 0: jdbc:hive2://10.18.98.34:23040> load data inpath > "hdfs://hacluster/chetan/orders.tbl.1" into table ORDERS > options('DELIMITER'='|','FILEHEADER'='O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT','batch_sort_size_inmb'='32'); > +---------+--+ > | Result | > +---------+--+ > +---------+--+ > No rows selected (23.228 seconds) > 0: jdbc:hive2://10.18.98.34:23040> update test_Db1.ORDERS set (o_comment) = > ('yyy'); > Issue : Update fails incorrectly with error for table created in external db > location. > 0: jdbc:hive2://10.18.98.34:23040> update test_Db1.ORDERS set (o_comment) = > ('yyy'); > *Error: java.lang.RuntimeException: Update operation failed. Multiple input > rows matched for same row. (state=,code=0)* > Expected : The update should be success for table created in external db > location. -- This message was sent by Atlassian JIRA (v6.4.14#64029)