carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CARBONDATA-326) Creates wrong table on 'create table like'
Date Fri, 21 Oct 2016 21:51:58 GMT

    [ 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 <zhangshunyu@huawei.com>
Date:   2016-10-21T21:30:43Z

    Carbon not supprt 'create table like' and hive support

commit 224216d1005cb49331e9bf62a628144d7495fd66
Author: Zhangshunyu <zhangshunyu@huawei.com>
Date:   2016-10-21T21:45:20Z

    Carbon not supprt 'create table like' and hive support

commit 4acfd3c8e8b63075fdff3f510290be11827c18e0
Author: Zhangshunyu <zhangshunyu@huawei.com>
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)

Mime
View raw message