Return-Path: <dev-return-32613-archive-asf-public=cust-asf.ponee.io@sqoop.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id 35A5D200B81
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Tue, 13 Sep 2016 11:04:22 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id 343F8160AC6; Tue, 13 Sep 2016 09:04:22 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id AA387160AD2
	for <archive-asf-public@cust-asf.ponee.io>; Tue, 13 Sep 2016 11:04:21 +0200 (CEST)
Received: (qmail 59245 invoked by uid 500); 13 Sep 2016 09:04:20 -0000
Mailing-List: contact dev-help@sqoop.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@sqoop.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@sqoop.apache.org>
List-Post: <mailto:dev@sqoop.apache.org>
List-Id: <dev.sqoop.apache.org>
Reply-To: dev@sqoop.apache.org
Delivered-To: mailing list dev@sqoop.apache.org
Received: (qmail 59222 invoked by uid 99); 13 Sep 2016 09:04:20 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Sep 2016 09:04:20 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id 944842C1B7B
	for <dev@sqoop.apache.org>; Tue, 13 Sep 2016 09:04:20 +0000 (UTC)
Date: Tue, 13 Sep 2016 09:04:20 +0000 (UTC)
From: "Hui Cao (JIRA)" <jira@apache.org>
To: dev@sqoop.apache.org
Message-ID: <JIRA.13004534.1473757426000.557465.1473757460604@Atlassian.JIRA>
In-Reply-To: <JIRA.13004534.1473757426000@Atlassian.JIRA>
References: <JIRA.13004534.1473757426000@Atlassian.JIRA> <JIRA.13004534.1473757426832@arcas>
Subject: [jira] [Created] (SQOOP-3011) sqoop import to HIVE external table
 based on file system other than HDFS
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
archived-at: Tue, 13 Sep 2016 09:04:22 -0000

Hui Cao created SQOOP-3011:
------------------------------

             Summary: sqoop import to HIVE external table based on file sys=
tem 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


1, Create external Hive table using swift URI in Hive shell
=09CREATE TABLE foo(id INT, msg STRING, INT) ROW FORMAT
=09DELIMITED FIELDS TERMINATED BY ','
=09LINES TERMINATED BY '\n'=20
=09STORED AS TEXTFILE
=09LOCATION =E2=80=99swift://swift.location/=E2=80=99;
  This table is created on an external file system instead of hdfs, in this=
 case, I=E2=80=99m using swift Object Store

2, Use sqoop to insert data to this table,=20
$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 con=
flict.





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