You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "anubhav tarar (JIRA)" <ji...@apache.org> on 2017/12/15 08:16:00 UTC
[jira] [Commented] (CARBONDATA-1731) Carbon1.3.0- DB creation
external path: Update fails incorrectly with error for table created in
external db location
[ https://issues.apache.org/jira/browse/CARBONDATA-1731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16292188#comment-16292188 ]
anubhav tarar commented on CARBONDATA-1731:
-------------------------------------------
it is solved with jira https://github.com/apache/carbondata/pull/1660/
> 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: 1.5h
> 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)