Re: Hive External Table issue

2013-06-20 Thread Stephen Sprague
>>>>>>> >>>>>>> In HDFS: file exists >>>>>>> >>>>>>> >>>>>>> >>>>>>> hadoop fs -ls >>>>>>> >>>>>>>

Re: Hive External Table issue

2013-06-20 Thread Nitin Pawar
;>>> >>>>>> /user/flume/events/request_logs/ >>>>>> ar1.vgs.mypoints.com/13-06-13/FlumeData.1371144648033 >>>>>> >>>>>> Found 1 items >>>>>> >>>>>> -rw-r--r-- 3 hdfs supergroup 2242037

Re: Hive External Table issue

2013-06-20 Thread Ramki Palle
242037226 2013-06-13 11:14 >>>>> >>>>> /user/flume/events/request_logs/ >>>>> ar1.vgs.mypoints.com/13-06-13/FlumeData.1371144648033 >>>>> >>>>> so the directory and file both exists. >>>>> >>>>>

Re: Hive External Table issue

2013-06-20 Thread Nitin Pawar
;> so the directory and file both exists. >>>> >>>> >>>> On Thu, Jun 20, 2013 at 10:24 AM, Nitin Pawar >>>> wrote: >>>> >>>>> MetaException(message:hdfs:// >>>>> h1.vgs.mypoints.com:8020/user/f

Re: Hive External Table issue

2013-06-20 Thread Ramki Palle
;> >>>> MetaException(message:hdfs:// >>>> h1.vgs.mypoints.com:8020/user/flume/events/request_logs/ar1.vgs.mypoints.com/13-06-13/FlumeData.1371144648033 >>>> >>>> is not a directory or unable to create one) >>>> >>>

Re: Hive External Table issue

2013-06-20 Thread Nitin Pawar
AM, Nitin Pawar >>> wrote: >>> >>>> MetaException(message:hdfs:// >>>> h1.vgs.mypoints.com:8020/user/flume/events/request_logs/ar1.vgs.mypoints.com/13-06-13/FlumeData.1371144648033 >>>> >>>> is not a directory or unable to

Re: Hive External Table issue

2013-06-20 Thread sanjeev sagar
>>> >>> is not a directory or unable to create one) >>> >>> >>> it clearly says its not a directory. Point to the dictory and it will >>> work >>> >>> >>> On Thu, Jun 20, 2013 at 10:52 PM, sanjeev sagar >> > wrote

Re: Hive External Table issue

2013-06-20 Thread Nitin Pawar
e one) >> >> >> it clearly says its not a directory. Point to the dictory and it will >> work >> >> >> On Thu, Jun 20, 2013 at 10:52 PM, sanjeev sagar >> wrote: >> >>> Hello Everyone, I'm running into the following Hive external t

Re: Hive External Table issue

2013-06-20 Thread sanjeev sagar
meData.1371144648033 > > is not a directory or unable to create one) > > > it clearly says its not a directory. Point to the dictory and it will work > > > On Thu, Jun 20, 2013 at 10:52 PM, sanjeev sagar > wrote: > >> Hello Everyone, I'm running into the follow

Re: Hive External Table issue

2013-06-20 Thread Nitin Pawar
, sanjeev sagar wrote: > Hello Everyone, I'm running into the following Hive external table issue. > > > > hive> CREATE EXTERNAL TABLE access( > > > host STRING, > > > identity STRING, > > > user STRING, > >

Hive External Table issue

2013-06-20 Thread sanjeev sagar
Hello Everyone, I'm running into the following Hive external table issue. hive> CREATE EXTERNAL TABLE access( > host STRING, > identity STRING, > user STRING, > time STRING, > request STRING,