Got it.
Thanks,
MIS.
On Fri, Sep 9, 2011 at 4:38 PM, Adriaan Tijsseling
wrote:
> I figured it out. A jar is missing.
>
> ./src/build/contrib/hive-contrib-0.7.1.jar
>
> If you don't see this jar, you need to go into src and run `ant` to build
> the extra jars.
>
> Then, you can do:
> DROP TABLE
I figured it out. A jar is missing.
./src/build/contrib/hive-contrib-0.7.1.jar
If you don't see this jar, you need to go into src and run `ant` to build the
extra jars.
Then, you can do:
DROP TABLE serde_regex;
add jar ./src/build/contrib/hive-contrib-0.7.1.jar;
create the table, load the data
Exactly what I meant. Can some one please let me know the right way of doing
or am I missing something ?
-MIS.
On Fri, Sep 9, 2011 at 4:13 PM, Adriaan Tijsseling
wrote:
> I can replicate it using this example. A
> SELECT * FROM serde_regex;
> works, but
> SELECT host FROM serde_regex;
> doesn't:
I can replicate it using this example. A
SELECT * FROM serde_regex;
works, but
SELECT host FROM serde_regex;
doesn't:
hive> SELECT host FROM serde_regex;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201109
The issue can be reproduced by following the example in contrib:
*
hive/contrib/src/test/queries/clientpositive/serde_regex.q*
sample log data can be obtained from there itself.
By the way, my version of hive is 0.7.0 , hadoop 0.20.2
Thanks,
MIS.
On Fri, Sep 9, 2011 at 2:55 PM, Ankit Jain wr
can you provide me sample log data
Thanks,
Ankit
On Fri, Sep 9, 2011 at 2:33 AM, MIS wrote:
> I want to access individual columns from a table created with row delimited
> by RegexSerde.
>
> For example,
> I have created a table as below:
>
> create table test ( col1 STRING, col2 STRING )
> R
