sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pratik Khadloya (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-1520) The table is null when using import into hive as parquet file and query option
Date Mon, 13 Oct 2014 14:29:33 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-1520?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14169340#comment-14169340
] 

Pratik Khadloya commented on SQOOP-1520:
----------------------------------------

Thanks Richard. The "test" table in hive needs to be created by the hive import option right?
I will give provide you the output of "import into hdfs as parquet file".

> The table is null when using import into hive as parquet file and query option
> ------------------------------------------------------------------------------
>
>                 Key: SQOOP-1520
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1520
>             Project: Sqoop
>          Issue Type: Bug
>          Components: hive-integration
>    Affects Versions: 1.4.5
>            Reporter: Richard
>            Assignee: Richard
>             Fix For: 1.4.6
>
>         Attachments: diff.patch, hadoop-hadoop-tasktracker-xxx.log, hive-site.xml
>
>
> {code}
> sh sqoop import --connect jdbc:mysql://server-391/test --username admin --password admin
--target-dir /user/pkhadloya/sqoop/extusersegments --hive-import --hive-table extusersegments
--create-hive-table --as-parquetfile --query "select * from test where \$CONDITIONS" --split-by
id
> {code}
> {code:title=hive}
> 0: jdbc:hive2://server-393:10000/default> show tables;
> +-----------+--+
> | tab_name  |
> +-----------+--+
> | null      |
> +-----------+--+
> 1 row selected (0.041 seconds)
> 0: jdbc:hive2://server-393:10000/default> select * from null;
> +----------+------------+--+
> | null.id  | null.name  |
> +----------+------------+--+
> | 1        | richard    |
> +----------+------------+--+
> 1 row selected (2.062 seconds)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message