study-day opened a new issue #4181:
URL: https://github.com/apache/carbondata/issues/4181


   
https://cwiki.apache.org/confluence/display/CARBONDATA/Apache+CarbonData+2.1.1+Release
 
   it does not support merge into ,please modify the document.
   ```
   hive --version  Hive 1.2.1000.2.6.5.0-292
   [hdfs@hadoop-node-1 spark-2.3.4-bin-hadoop2.7]$ bin/beeline
   Beeline version 1.2.1.spark2 by Apache Hive
   beeline> !connect jdbc:hive2://hadoop-node-1:10000
   Connecting to jdbc:hive2://hadoop-node-1:10000
   Enter username for jdbc:hive2://hadoop-node-1:10000: abcdsesss
   Enter password for jdbc:hive2://hadoop-node-1:10000: **********
   Connected to: Spark SQL (version 2.3.4)
   Driver: Hive JDBC (version 1.2.1.spark2)
   Transaction isolation: TRANSACTION_REPEATABLE_READ
   
   0: jdbc:hive2://hadoop-node-1:10000> merge into test_table t using ( select 
t1.name name,t1.id age, t1.age id, t1.city city from test_table t1 )s on 
(t.id=s.id) when matched then update set t.age=s.age  ;
   Error: 
org.apache.carbondata.common.exceptions.sql.MalformedCarbonCommandException: 
Parse failed! (state=,code=0)
   0: jdbc:hive2://hadoop-node-1:10000>
   
   ```
   finally,MERGE is available starting in Hive 2.2. and carbondata table is  
the table that support ACID ?
   ```
   Merge
   Version Information
   
   MERGE is available starting in Hive 2.2.
   
   Merge can only be performed on tables that support ACID. See Hive 
Transactions for details.
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@carbondata.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Reply via email to