Re: Question regarding external table and csv in NFS

[Mainak Ghosh]

Hey Everybody,

This problem still did not work. Any advice?

Thanks and Regards,
Mainak.



From:   Mainak Ghosh/Almaden/IBM@IBMUS
To:     user@hive.apache.org,
Date:   07/17/2013 02:12 PM
Subject:        Re: Question regarding external table and csv in NFS



Hey Saurabh,

I tried this command and it still gives the same error. Actually the folder
name is supplier and supplier.tbl is the csv which resided inside it. I had
it correct in the query but in mail it is wrong. So the query that I
executed was:


create external table outside_supplier (S_SUPPKEY INT, S_NAME STRING,
S_ADDRESS STRING, S_NATIONKEY INT, S_PHONE STRING, S_ACCTBAL DOUBLE,
S_COMMENT STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS
TEXTFILE LOCATION 'file:///mnt/h/tpc-h-impala/data/supplier';


Thanks and Regards,
Mainak.

Inactive hide details for Saurabh M ---07/17/2013 02:06:36 PM---Hi Mainak,
Can you try using this:Saurabh M ---07/17/2013 02:06:36 PM---Hi Mainak, Can
you try using this:

From: Saurabh M <mpp.databa...@gmail.com>
To: user@hive.apache.org,
Date: 07/17/2013 02:06 PM
Subject: Re: Question regarding external table and csv in NFS



Hi Mainak,


Can you try using this:


 create external table outside_supplier (S_SUPPKEY INT, S_NAME STRING,
S_ADDRESS STRING, S_NATIONKEY INT, S_PHONE STRING, S_ACCTBAL DOUBLE,
S_COMMENT STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS
TEXTFILE LOCATION 'file:///mnt/h/tpc-h-impala/data/supplier.tbl';


I assume that "supplier.tbl" is a directory and the csv file is present in
the same.


Let me know if it worked!


Thanks,


Saurabh




On Thu, Jul 18, 2013 at 1:55 AM, Mainak Ghosh <gho...@us.ibm.com> wrote:
      Hello,

      I have just started using Hive and I was trying to create an external
      table with the csv file placed in NFS. I tried using file:// and
      local://. Both of these attempts failed with the error:

      create external table outside_supplier (S_SUPPKEY INT, S_NAME STRING,
      S_ADDRESS STRING, S_NATIONKEY INT, S_PHONE STRING, S_ACCTBAL DOUBLE,
      S_COMMENT STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
      STORED AS TEXTFILE LOCATION
      'local://mnt/h/tpc-h-impala/data/supplier.tbl';

      FAILED: Error in metadata: MetaException(message:Got exception:
      java.io.IOException No FileSystem for scheme: local)

      and

      create external table outside_supplier (S_SUPPKEY INT, S_NAME STRING,
      S_ADDRESS STRING, S_NATIONKEY INT, S_PHONE STRING, S_ACCTBAL DOUBLE,
      S_COMMENT STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
      STORED AS TEXTFILE LOCATION
      'file://mnt/h/tpc-h-impala/data/supplier.tbl';

      FAILED: Error in metadata: MetaException
      (message:file:/h/tpc-h-impala/data/supplier.tbl is not a directory or
      unable to create one)

      Am I missing some configuration? Any help would be really
      appreciated.

      Thanks and Regards,
      Mainak.

<<inline: graycol.gif>>