carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravindra Pesala (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CARBONDATA-326) Creates wrong table on 'create table like'
Date Mon, 16 Jan 2017 17:48:26 GMT

     [ https://issues.apache.org/jira/browse/CARBONDATA-326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ravindra Pesala updated CARBONDATA-326:
---------------------------------------
    Assignee: zhangshunyu

> 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
>            Assignee: zhangshunyu
>          Time Spent: 1h 50m
>  Remaining Estimate: 0h
>
> 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