carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "anubhav tarar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CARBONDATA-1441) schema change does not reflect back in hive when schema is alter in carbon
Date Thu, 31 Aug 2017 11:53:01 GMT
anubhav tarar created CARBONDATA-1441:
-----------------------------------------

             Summary: schema change does not reflect back in hive when schema is alter in
carbon
                 Key: CARBONDATA-1441
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1441
             Project: CarbonData
          Issue Type: Bug
          Components: hive-integration
         Environment: spark2.1,hadoop2.7,hive 1.2.1
            Reporter: anubhav tarar
            Assignee: anubhav tarar
            Priority: Minor


steps to reproduce

1. alter table schema in hive

0: jdbc:hive2://localhost:10000> desc uniqdata;
+----------------------+-----------------+----------+--+
|       col_name       |    data_type    | comment  |
+----------------------+-----------------+----------+--+
| CUST_ID              | int             | NULL     |
| CUST_NAME            | string          | NULL     |
| ACTIVE_EMUI_VERSION  | string          | NULL     |
| DOB                  | timestamp       | NULL     |
| DOJ                  | timestamp       | NULL     |
| BIGINT_COLUMN1       | bigint          | NULL     |
| BIGINT_COLUMN2       | bigint          | NULL     |
| DECIMAL_COLUMN1      | decimal(30,10)  | NULL     |
| DECIMAL_COLUMN2      | decimal(36,10)  | NULL     |
| Double_COLUMN1       | double          | NULL     |
| Double_COLUMN2       | double          | NULL     |
| INTEGER_COLUMN1      | int             | NULL     |
+----------------------+-----------------+----------+--+
12 rows selected (0.638 seconds)
0: jdbc:hive2://localhost:10000> alter table uniqdata change cust_id cust_id long;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (7.619 seconds)
0: jdbc:hive2://localhost:10000> desc uniqdata;
+----------------------+-----------------+----------+--+
|       col_name       |    data_type    | comment  |
+----------------------+-----------------+----------+--+
| cust_id              | bigint          | NULL     |
| cust_name            | string          | NULL     |
| active_emui_version  | string          | NULL     |
| dob                  | timestamp       | NULL     |
| doj                  | timestamp       | NULL     |
| bigint_column1       | bigint          | NULL     |
| bigint_column2       | bigint          | NULL     |
| decimal_column1      | decimal(30,10)  | NULL     |
| decimal_column2      | decimal(36,10)  | NULL     |
| double_column1       | double          | NULL     |
| double_column2       | double          | NULL     |
| integer_column1      | int             | NULL     |
+----------------------+-----------------+----------+--+
12 rows selected (0.431 seconds)

2.start hive cli and desc same table

0: jdbc:hive2://localhost:10000> desc uniqdata;
+----------------------+-----------------+----------+--+
|       col_name       |    data_type    | comment  |
+----------------------+-----------------+----------+--+
| 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             |          |
+----------------------+------------

schema change is not reflected in hive when reading carbondata file





--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message