GitHub user Zhangshunyu opened a pull request:
https://github.com/apache/incubator-carbondata/pull/254
[CARBONDATA-326] Creates wrong table on 'create table like'
## Why raise this pr?
For fix this problem on jira:
```
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)
```
Since carbon not supprut 'create table like', when the table is carbon
table, we should throw error to the user and not create such a table,
meanwhile, we should also not have effect on hive tables.
## How to test?
Pass all the test cases and the new added testcase.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/Zhangshunyu/incubator-carbondata createlike
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-carbondata/pull/254.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #254
----
commit 0af3a8150ef5821c4c4a4fc0aa3df1b03694da64
Author: Zhangshunyu <[email protected]>
Date: 2016-10-21T21:30:43Z
Carbon not supprt 'create table like' and hive support
commit 224216d1005cb49331e9bf62a628144d7495fd66
Author: Zhangshunyu <[email protected]>
Date: 2016-10-21T21:45:20Z
Carbon not supprt 'create table like' and hive support
commit 4acfd3c8e8b63075fdff3f510290be11827c18e0
Author: Zhangshunyu <[email protected]>
Date: 2016-10-21T21:47:48Z
Carbon not supprt 'create table like' and hive support
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
