[jira] [Commented] (CARBONDATA-326) Creates wrong table on 'create table like'

[Akash R Nilugal (Jira)]

    [ 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 <[hidden email]>
Date:   2016-10-21T21:30:43Z

    Carbon not supprt 'create table like' and hive support

commit 224216d1005cb49331e9bf62a628144d7495fd66
Author: Zhangshunyu <[hidden email]>
Date:   2016-10-21T21:45:20Z

    Carbon not supprt 'create table like' and hive support

commit 4acfd3c8e8b63075fdff3f510290be11827c18e0
Author: Zhangshunyu <[hidden email]>
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)