Prabhat Kashyap created CARBONDATA-326:
------------------------------------------
Summary: Creates wrong table on 'create table like'
Key: CARBONDATA-326
URL: https://issues.apache.org/jira/browse/CARBONDATA-326
Project: CarbonData
Issue Type: Bug
Reporter: Prabhat Kashyap
I'm trying to create a table like my old table but it is not creating as
expected.
0: jdbc:hive2://localhost:10000> CREATE TABLE mainTable(id INT, name STRING)
STORED BY 'carbondata';
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (0.206 seconds)
0: jdbc:hive2://localhost:10000> DESC mainTable;
+-----------+------------+----------+--+
| col_name | data_type | comment |
+-----------+------------+----------+--+
| name | string | |
| id | bigint | |
+-----------+------------+----------+--+
2 rows selected (0.056 seconds)
Above one is my mainTable and I wants to create copiedTable from it but
everytime it is show something like:
0: jdbc:hive2://localhost:10000> CREATE TABLE copiedTable LIKE mainTable;
+---------+--+
| result |
+---------+--+
+---------+--+
No rows selected (0.101 seconds)
0: jdbc:hive2://localhost:10000> DESC copiedTable;
+-----------+----------------+--------------------+--+
| col_name | data_type | comment |
+-----------+----------------+--------------------+--+
| col | array<string> | from deserializer |
+-----------+----------------+--------------------+--+
1 row selected (0.022 seconds)
0: jdbc:hive2://localhost:10000> LOAD DATA LOCAL INPATH
'hdfs://localhost:54310/user/hduser/datafiles/data.csv' INTO TABLE copiedTable
OPTIONS('DELIMITER'=',');
Error: java.lang.RuntimeException: Data loading failed. table not found:
knoldus.copiedtable (state=,code=0)
0: jdbc:hive2://localhost:10000> select * from copiedTable;
+------+--+
| col |
+------+--+
+------+--+
No rows selected (0.11 seconds)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
