Re: Question regarding external table and csv in NFS

2013-07-19 Thread 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

Re: Question regarding external table and csv in NFS

2013-07-17 Thread Mainak Ghosh
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

Re: Question regarding external table and csv in NFS

2013-07-17 Thread Saurabh M
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

Question regarding external table and csv in NFS

2013-07-17 Thread Mainak Ghosh
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