[SQOOP-1520] The table is null when using import into hive as parquet file and query option

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.5
• Fix Version/s: 1.4.6
• Component/s: hive-integration
• Assignee: Richard
• Reporter: Richard
• Created: 15/Sep/14 02:15
• Updated: 14/Oct/14 02:36
• Resolved: 17/Sep/14 07:45

Description

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

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)