You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Ray Duong <ra...@gmail.com> on 2009/07/20 16:25:29 UTC
Newbie Question - Error reading example files
Hi Hive Users.
I'm a newbie to hive so this might be a dumb configuration issue. I am
trying to run Hive on Amazon EC2 and getting an error when attempting to
follow the sample script from the Hive wiki site. I'm able to create and
load the data but not able to read the content of the file. Was there a
step that I missed during the Hive startup?
Thanks,
-ray
Logging in to host ec2-75-101-208-214.compute-1.amazonaws.com.
__| __|_ ) Fedora 8
_| ( / 32-bit
___|\___|___|
Welcome to an EC2 Public Image
:-)
Base
[root@domU-12-31-39-00-89-56 ~]# ls
ec2-ami-tools-1.3-19974.noarch.rpm
cd /usr/local/hadoop-0.19.0/contrib/hive
[root@domU-12-31-39-00-89-56 hive]# bin/hive
hive> CREATE TABLE pokes (foo INT, bar STRING);
OK
Time taken: 12.545 seconds
hive> CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING);
OK
Time taken: 0.129 seconds
hive> LOAD DATA LOCAL INPATH './examples/files/kv1.txt' OVERWRITE INTO TABLE
pokes;
Copying data from
file:/usr/local/hadoop-0.19.0/contrib/hive/examples/files/kv1.txt
Loading data to table pokes
OK
Time taken: 1.963 seconds
hive> select * from pokes;
FAILED: Parse Error: line 1:7 cannot recognize input '*'
Re: Newbie Question - Error reading example files
Posted by Ray Duong <ra...@gmail.com>.
Thanks that seems to work.
-ray
On Wed, Jul 22, 2009 at 2:10 PM, Zheng Shao <zs...@gmail.com> wrote:
> HI Ray,
>
> This error usually happens if Hive.g is updated but "ant clean" is not
> run before "ant package".
>
> Can you try "ant clean" and rebuild the code?
>
> Zheng
>
> On Mon, Jul 20, 2009 at 7:57 AM, Ray Duong<ra...@gmail.com> wrote:
> > Hi Tim,
> >
> > I'm still getting an error, when specifying the column names.
> >
> >
> > hive> describe extended pokes;
> > OK
> > foo int
> > bar string
> > Detailed Table Information:
> >
> Table(tableName:pokes,dbName:default,owner:root,createTime:1248099183,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:foo,type:int,comment:null),
> >
> FieldSchema(name:bar,type:string,comment:null)],location:/user/hive/warehouse/pokes,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{SORTBUCKETCOLSPREFIX=TRUE})
> > Time taken: 0.165 seconds
> >
> > hive> select foo, bar from pokes;
> > FAILED: Parse Error: line 1:7 cannot recognize input 'foo'
> >
> > Time taken: 0.0090 seconds
> >
> > Thanks,
> > -ray
> >
> > On Mon, Jul 20, 2009 at 7:42 AM, tim robertson <
> timrobertson100@gmail.com>
> > wrote:
> >>
> >> Can you please try
> >>
> >> select foo,bar from pokes;
> >>
> >> ?
> >>
> >>
> >>
> >> On Mon, Jul 20, 2009 at 4:25 PM, Ray Duong<ra...@gmail.com> wrote:
> >> > Hi Hive Users.
> >> >
> >> > I'm a newbie to hive so this might be a dumb configuration issue. I
> am
> >> > trying to run Hive on Amazon EC2 and getting an error when attempting
> to
> >> > follow the sample script from the Hive wiki site. I'm able to create
> >> > and
> >> > load the data but not able to read the content of the file. Was there
> a
> >> > step that I missed during the Hive startup?
> >> >
> >> > Thanks,
> >> > -ray
> >> >
> >> >
> >> > Logging in to host ec2-75-101-208-214.compute-1.amazonaws.com.
> >> >
> >> > __| __|_ ) Fedora 8
> >> > _| ( / 32-bit
> >> > ___|\___|___|
> >> >
> >> > Welcome to an EC2 Public Image
> >> > :-)
> >> > Base
> >> >
> >> > [root@domU-12-31-39-00-89-56 ~]# ls
> >> > ec2-ami-tools-1.3-19974.noarch.rpm
> >> >
> >> > cd /usr/local/hadoop-0.19.0/contrib/hive
> >> >
> >> > [root@domU-12-31-39-00-89-56 hive]# bin/hive
> >> >
> >> > hive> CREATE TABLE pokes (foo INT, bar STRING);
> >> > OK
> >> > Time taken: 12.545 seconds
> >> > hive> CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds
> >> > STRING);
> >> > OK
> >> > Time taken: 0.129 seconds
> >> > hive> LOAD DATA LOCAL INPATH './examples/files/kv1.txt' OVERWRITE INTO
> >> > TABLE
> >> > pokes;
> >> > Copying data from
> >> > file:/usr/local/hadoop-0.19.0/contrib/hive/examples/files/kv1.txt
> >> > Loading data to table pokes
> >> > OK
> >> > Time taken: 1.963 seconds
> >> > hive> select * from pokes;
> >> > FAILED: Parse Error: line 1:7 cannot recognize input '*'
> >> >
> >> >
> >
> >
>
>
>
> --
> Yours,
> Zheng
>
Re: Newbie Question - Error reading example files
Posted by Zheng Shao <zs...@gmail.com>.
HI Ray,
This error usually happens if Hive.g is updated but "ant clean" is not
run before "ant package".
Can you try "ant clean" and rebuild the code?
Zheng
On Mon, Jul 20, 2009 at 7:57 AM, Ray Duong<ra...@gmail.com> wrote:
> Hi Tim,
>
> I'm still getting an error, when specifying the column names.
>
>
> hive> describe extended pokes;
> OK
> foo int
> bar string
> Detailed Table Information:
> Table(tableName:pokes,dbName:default,owner:root,createTime:1248099183,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:foo,type:int,comment:null),
> FieldSchema(name:bar,type:string,comment:null)],location:/user/hive/warehouse/pokes,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{SORTBUCKETCOLSPREFIX=TRUE})
> Time taken: 0.165 seconds
>
> hive> select foo, bar from pokes;
> FAILED: Parse Error: line 1:7 cannot recognize input 'foo'
>
> Time taken: 0.0090 seconds
>
> Thanks,
> -ray
>
> On Mon, Jul 20, 2009 at 7:42 AM, tim robertson <ti...@gmail.com>
> wrote:
>>
>> Can you please try
>>
>> select foo,bar from pokes;
>>
>> ?
>>
>>
>>
>> On Mon, Jul 20, 2009 at 4:25 PM, Ray Duong<ra...@gmail.com> wrote:
>> > Hi Hive Users.
>> >
>> > I'm a newbie to hive so this might be a dumb configuration issue. I am
>> > trying to run Hive on Amazon EC2 and getting an error when attempting to
>> > follow the sample script from the Hive wiki site. I'm able to create
>> > and
>> > load the data but not able to read the content of the file. Was there a
>> > step that I missed during the Hive startup?
>> >
>> > Thanks,
>> > -ray
>> >
>> >
>> > Logging in to host ec2-75-101-208-214.compute-1.amazonaws.com.
>> >
>> > __| __|_ ) Fedora 8
>> > _| ( / 32-bit
>> > ___|\___|___|
>> >
>> > Welcome to an EC2 Public Image
>> > :-)
>> > Base
>> >
>> > [root@domU-12-31-39-00-89-56 ~]# ls
>> > ec2-ami-tools-1.3-19974.noarch.rpm
>> >
>> > cd /usr/local/hadoop-0.19.0/contrib/hive
>> >
>> > [root@domU-12-31-39-00-89-56 hive]# bin/hive
>> >
>> > hive> CREATE TABLE pokes (foo INT, bar STRING);
>> > OK
>> > Time taken: 12.545 seconds
>> > hive> CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds
>> > STRING);
>> > OK
>> > Time taken: 0.129 seconds
>> > hive> LOAD DATA LOCAL INPATH './examples/files/kv1.txt' OVERWRITE INTO
>> > TABLE
>> > pokes;
>> > Copying data from
>> > file:/usr/local/hadoop-0.19.0/contrib/hive/examples/files/kv1.txt
>> > Loading data to table pokes
>> > OK
>> > Time taken: 1.963 seconds
>> > hive> select * from pokes;
>> > FAILED: Parse Error: line 1:7 cannot recognize input '*'
>> >
>> >
>
>
--
Yours,
Zheng
Re: Newbie Question - Error reading example files
Posted by Ray Duong <ra...@gmail.com>.
Hi Tim,
I'm still getting an error, when specifying the column names.
hive> describe extended pokes;
OK
foo int
bar string
Detailed Table Information:
Table(tableName:pokes,dbName:default,owner:root,createTime:1248099183,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:foo,type:int,comment:null),
FieldSchema(name:bar,type:string,comment:null)],location:/user/hive/warehouse/pokes,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{SORTBUCKETCOLSPREFIX=TRUE})
Time taken: 0.165 seconds
hive> select foo, bar from pokes;
FAILED: Parse Error: line 1:7 cannot recognize input 'foo'
Time taken: 0.0090 seconds
Thanks,
-ray
On Mon, Jul 20, 2009 at 7:42 AM, tim robertson <ti...@gmail.com>wrote:
> Can you please try
>
> select foo,bar from pokes;
>
> ?
>
>
>
> On Mon, Jul 20, 2009 at 4:25 PM, Ray Duong<ra...@gmail.com> wrote:
> > Hi Hive Users.
> >
> > I'm a newbie to hive so this might be a dumb configuration issue. I am
> > trying to run Hive on Amazon EC2 and getting an error when attempting to
> > follow the sample script from the Hive wiki site. I'm able to create and
> > load the data but not able to read the content of the file. Was there a
> > step that I missed during the Hive startup?
> >
> > Thanks,
> > -ray
> >
> >
> > Logging in to host ec2-75-101-208-214.compute-1.amazonaws.com.
> >
> > __| __|_ ) Fedora 8
> > _| ( / 32-bit
> > ___|\___|___|
> >
> > Welcome to an EC2 Public Image
> > :-)
> > Base
> >
> > [root@domU-12-31-39-00-89-56 ~]# ls
> > ec2-ami-tools-1.3-19974.noarch.rpm
> >
> > cd /usr/local/hadoop-0.19.0/contrib/hive
> >
> > [root@domU-12-31-39-00-89-56 hive]# bin/hive
> >
> > hive> CREATE TABLE pokes (foo INT, bar STRING);
> > OK
> > Time taken: 12.545 seconds
> > hive> CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds
> STRING);
> > OK
> > Time taken: 0.129 seconds
> > hive> LOAD DATA LOCAL INPATH './examples/files/kv1.txt' OVERWRITE INTO
> TABLE
> > pokes;
> > Copying data from
> > file:/usr/local/hadoop-0.19.0/contrib/hive/examples/files/kv1.txt
> > Loading data to table pokes
> > OK
> > Time taken: 1.963 seconds
> > hive> select * from pokes;
> > FAILED: Parse Error: line 1:7 cannot recognize input '*'
> >
> >
>
Re: Newbie Question - Error reading example files
Posted by tim robertson <ti...@gmail.com>.
Can you please try
select foo,bar from pokes;
?
On Mon, Jul 20, 2009 at 4:25 PM, Ray Duong<ra...@gmail.com> wrote:
> Hi Hive Users.
>
> I'm a newbie to hive so this might be a dumb configuration issue. I am
> trying to run Hive on Amazon EC2 and getting an error when attempting to
> follow the sample script from the Hive wiki site. I'm able to create and
> load the data but not able to read the content of the file. Was there a
> step that I missed during the Hive startup?
>
> Thanks,
> -ray
>
>
> Logging in to host ec2-75-101-208-214.compute-1.amazonaws.com.
>
> __| __|_ ) Fedora 8
> _| ( / 32-bit
> ___|\___|___|
>
> Welcome to an EC2 Public Image
> :-)
> Base
>
> [root@domU-12-31-39-00-89-56 ~]# ls
> ec2-ami-tools-1.3-19974.noarch.rpm
>
> cd /usr/local/hadoop-0.19.0/contrib/hive
>
> [root@domU-12-31-39-00-89-56 hive]# bin/hive
>
> hive> CREATE TABLE pokes (foo INT, bar STRING);
> OK
> Time taken: 12.545 seconds
> hive> CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING);
> OK
> Time taken: 0.129 seconds
> hive> LOAD DATA LOCAL INPATH './examples/files/kv1.txt' OVERWRITE INTO TABLE
> pokes;
> Copying data from
> file:/usr/local/hadoop-0.19.0/contrib/hive/examples/files/kv1.txt
> Loading data to table pokes
> OK
> Time taken: 1.963 seconds
> hive> select * from pokes;
> FAILED: Parse Error: line 1:7 cannot recognize input '*'
>
>