[
https://issues.apache.org/jira/browse/CARBONDATA-326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15596482#comment-15596482
]
ASF GitHub Bot commented on CARBONDATA-326:
-------------------------------------------
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
----
> 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)
