You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Richard (JIRA)" <ji...@apache.org> on 2014/09/15 04:16:34 UTC
[jira] [Updated] (SQOOP-1520) The table is null when using import
into hive as parquet file and query option
[ https://issues.apache.org/jira/browse/SQOOP-1520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richard updated SQOOP-1520:
---------------------------
Description:
{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}
was:
{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}
> 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
>
> {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)