[jira] [Assigned] (SQOOP-3011) sqoop import to HIVE external table based on file system other than HDFS

["VISHNU S NAIR (JIRA)" <ji...@apache.org>]

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

VISHNU S NAIR reassigned SQOOP-3011:
------------------------------------

    Assignee: VISHNU S NAIR

> sqoop import to HIVE external table based on file system other than HDFS
> ------------------------------------------------------------------------
>
>                 Key: SQOOP-3011
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3011
>             Project: Sqoop
>          Issue Type: Bug
>    Affects Versions: 1.4.6
>            Reporter: Hui Cao
>            Assignee: VISHNU S NAIR
>
> 1, Create external Hive table using swift URI in Hive shell
> 	CREATE TABLE foo(id INT, msg STRING, INT) ROW FORMAT
> 	DELIMITED FIELDS TERMINATED BY ','
> 	LINES TERMINATED BY '\n' 
> 	STORED AS TEXTFILE
> 	LOCATION ’swift://swift.location/’;
>   This table is created on an external file system instead of hdfs, in this case, I’m using swift Object Store
> 2, Use sqoop to insert data to this table, 
> $SQOOP_PATH/sqoop import --driver com.ibm.db2.jcc.DB2Driver --connect jdbc:db://<dbhostname>:<port>/<db> --username <username> --password <password> --table FOO --hive-import --hive-home hive
> the process shows following error:
> FAILED: SemanticException [Error 10028]: Line 2:17 Path is not legal ''hdfs://<hostname>:8020/user/hdfs/FOO'': Move from: hdfs://<hostname>:8020/user/hdfs/FOO to: swift://swift.location/ is not valid. Please check that values for params "default.fs.name" and "hive.metastore.warehouse.dir" do not conflict.



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