[jira] [Created] (CARBONDATA-617) Insert query not working with UNION

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

[jira] [Created] (CARBONDATA-617) Insert query not working with UNION

Akash R Nilugal (Jira)
Deepti Bhardwaj created CARBONDATA-617:
------------------------------------------

             Summary: Insert query not working with UNION
                 Key: CARBONDATA-617
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-617
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 1.0.0-incubating
         Environment: Spark 1.6

            Reporter: Deepti Bhardwaj
            Priority: Minor


I created 3 table all havng same schema
Create table commands:

CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format';

CREATE TABLE student (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format';


CREATE TABLE department (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format';

and I loaded the uniqdata and department table with the attached CSV()



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)