You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Rahul Kumar (JIRA)" <ji...@apache.org> on 2018/07/08 13:46:00 UTC
[jira] [Updated] (CARBONDATA-2631) Update on the restructutred
table is failing sporadically.
[ https://issues.apache.org/jira/browse/CARBONDATA-2631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Kumar updated CARBONDATA-2631:
------------------------------------
Summary: Update on the restructutred table is failing sporadically. (was: Update on the CTAS table is failing sporadically.)
> Update on the restructutred table is failing sporadically.
> -----------------------------------------------------------
>
> Key: CARBONDATA-2631
> URL: https://issues.apache.org/jira/browse/CARBONDATA-2631
> Project: CarbonData
> Issue Type: Improvement
> Reporter: Rahul Kumar
> Assignee: Rahul Kumar
> Priority: Major
>
> *CTASÂ from Hive table:*
> spark.sql({color:#008000}"drop table if exists hive_tprop"{color})
> spark.sql({color:#008000}"CREATE TABLE IF NOT EXISTS hive_tprop ( eid int, name String,salary String, destination String,doj date, toj timestamp, abc decimal(8,2), test BIGINT) stored by 'carbondata' TBLPROPERTIES('DICTIONARY_INCLUDE'='eid','DICTIONARY_EXCLUDE'='name','No_Inverted_Index'='name','SORT_SCOPE'='global_sort')"{color})
> spark.sql({color:#008000}"insert into hive_tprop select 1,'rev','1000','ban','1999-01-12','1999-02-10 05:25:00',123456.25,564789"{color})
> spark.sql({color:#008000}"insert into hive_tprop select 2,'rev','1000','ban','2012-01-01','2012-02-10 05:25:00',123456.25,564789"{color})
> spark.sql({color:#008000}"alter table hive_tprop add columns (new_col1 INT)"{color})
> spark.sql({color:#008000}"update hive_tprop set (eid)=(3)"{color}).show()
> spark.sql({color:#008000}"select * from hive_tprop"{color}).show()
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)