Re: Can hive strip '#' comments in input data?

2011-04-04 Thread Edward Capriolo
2011/4/4 Bjørn Remseth : > Hi guys. > > I've got some input data with comment lines starting with '#' and lasting to > the end of line, like: >      #this is a comment > Is there a way to make hive ignore these comments when importing data > into a table? > > -- > >                            

Re: Can hive strip '#' comments in input data?

2011-04-04 Thread Sameer Kalburgi
Regexp e.g. "...WHERE line RLIKE '^#.*' = FALSE"? 2011/4/4 Bjørn Remseth > Hi guys. > > > I've got some input data with comment lines starting with '#' and lasting > to > the end of line, like: > > #this is a comment > > Is there a way to make hive ignore these comments when importing

Can hive strip '#' comments in input data?

2011-04-04 Thread Bjørn Remseth
Hi guys. I've got some input data with comment lines starting with '#' and lasting to the end of line, like: #this is a comment Is there a way to make hive ignore these comments when importing data into a table? -- (Rmz)

External Hive Table with sqoop import

2011-04-04 Thread Sharma, Akash
Hi, I am trying to create an external hive table (with data) using the sqoop import from the "--hive-import" command. The requirement is to actually create an "External" hive table instead of it being part of hive metastore. I wanted to know if there is a way to accomplish this using

Re: Hive in a readonly mode

2011-04-04 Thread Edward Capriolo
On Mon, Apr 4, 2011 at 3:00 AM, Guy Doulberg wrote: > Thanks, > > Upgrading hive 0.6 to 0.7 should be a problem? > > > -Original Message- > From: Edward Capriolo [mailto:edlinuxg...@gmail.com] > Sent: Wednesday, March 30, 2011 4:41 PM > To: user@hive.apache.org > Cc: Guy Doulberg > Subject

Re: Does Hive 0.7.0 support Hadoop 0.21.0?

2011-04-04 Thread Edward Capriolo
On Mon, Apr 4, 2011 at 9:50 AM, Xiaobo Gu wrote: > On Mon, Apr 4, 2011 at 9:49 PM, Edward Capriolo wrote: >> Xiaobo, >> >> No. it does not. Not many things support 0.21.0. It is considered the >> latest release but it is far from standard. Most people are still >> using patched versions of 0.20.X

Re: Does Hive 0.7.0 support Hadoop 0.21.0?

2011-04-04 Thread Xiaobo Gu
On Mon, Apr 4, 2011 at 9:49 PM, Edward Capriolo wrote: > Xiaobo, > > No. it does not. Not many things support 0.21.0. It is considered the > latest release but it is far from standard. Most people are still > using patched versions of 0.20.X Greenplum 4.1.0.0 supports Hadoop 0.21.0 only > > Than

Re: Does Hive 0.7.0 support Hadoop 0.21.0?

2011-04-04 Thread Edward Capriolo
Xiaobo, No. it does not. Not many things support 0.21.0. It is considered the latest release but it is far from standard. Most people are still using patched versions of 0.20.X Thank you, Edward On Mon, Apr 4, 2011 at 1:36 AM, 김영우 wrote: > Hi, > I believe you can track the issue from jira. > Se

RE: Hive in a readonly mode

2011-04-04 Thread Guy Doulberg
Thanks, Upgrading hive 0.6 to 0.7 should be a problem? -Original Message- From: Edward Capriolo [mailto:edlinuxg...@gmail.com] Sent: Wednesday, March 30, 2011 4:41 PM To: user@hive.apache.org Cc: Guy Doulberg Subject: Re: Hive in a readonly mode On Wed, Mar 30, 2011 at 9:29 AM, Guy Dou