carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chetan Bhat (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CARBONDATA-1731) (Carbon1.3.0- DB creation external path) Update fails incorrectly with error for table created in external db location
Date Thu, 16 Nov 2017 08:51:00 GMT
Chetan Bhat created CARBONDATA-1731:
---------------------------------------

             Summary: (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


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)

Mime
View raw message