[jira] [Created] (CARBONDATA-4134) MERGE INTO SQL Command is successful with wrong input for action

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-4134) MERGE INTO SQL Command is successful with wrong input for action

Karan (Jira)
PURUJIT CHAUGULE created CARBONDATA-4134:
--------------------------------------------

             Summary: MERGE INTO SQL Command is successful with wrong input for action
                 Key: CARBONDATA-4134
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-4134
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 2.1.0
         Environment: Spark 2.4.5
            Reporter: PURUJIT CHAUGULE


STEPS:

DROP TABLE IF EXISTS A;
DROP TABLE IF EXISTS B;
CREATE TABLE IF NOT EXISTS A(id Int,price Int, state String) STORED AS carbondata;
CREATE TABLE IF NOT EXISTS B(id Int, price Int,state String ) STORED AS carbondata;
 INSERT INTO A VALUES (1,100,"MA");
 INSERT INTO A VALUES (2,200,"NY");
 INSERT INTO A VALUES (3,300,"NH");
 INSERT INTO A VALUES (4,400,"FL");

INSERT INTO B VALUES (1,1,"MA (updated)");
 INSERT INTO B VALUES (2,3,"NY (updated)");
 INSERT INTO B VALUES (3,3,"CA (updated)");
 INSERT INTO B VALUES (5,5,"TX (updated)");
 INSERT INTO B VALUES (7,7,"LO (updated)");

0: jdbc:hive2://linux1:22550/> MERGE INTO A USING B ON A.ID=B.ID WHEN NOT MATCHED THEN;
+---------+
| Result |
+---------+
+---------+
No rows selected (16.256 seconds)
0: jdbc:hive2://linux1:22550/>
0: jdbc:hive2://linux1:22550/> MERGE INTO A USING B ON A.ID=B.ID WHEN NOT MATCHED THEN X;
+---------+
| Result |
+---------+
+---------+
No rows selected (5.565 seconds)
0: jdbc:hive2://linux1:22550/>
0: jdbc:hive2://linux1:22550/> MERGE INTO A USING B ON A.ID=B.ID WHEN MATCHED THEN a.b;
+---------+
| Result |
+---------+
+---------+
No rows selected (39.731 seconds)
0: jdbc:hive2://linux1:22550/>
0: jdbc:hive2://linux1:22550/> MERGE INTO A USING B ON A.ID=B.ID WHEN MATCHED THEN 1;
+---------+
| Result |
+---------+
+---------+
No rows selected (14.754 seconds)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)