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
rabh M
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_ACCTB
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/da
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_NATIONK