Thank you. I'll try it
On Apr 4, 2012, at 6:32 PM, "Alex Kozlov"
mailto:ale...@cloudera.com>> wrote:
It's octal.
On Wed, Apr 4, 2012 at 4:16 PM, Steven Wong
mailto:sw...@netflix.com>> wrote:
FIELDS TERMINATED BY '\001' is for chr(1). I’m not sure if it’s decimal or
octal. But you can test it
It's octal.
On Wed, Apr 4, 2012 at 4:16 PM, Steven Wong wrote:
> FIELDS TERMINATED BY '\001' is for chr(1). I’m not sure if it’s decimal
> or octal. But you can test it out.
>
> ** **
>
> ** **
>
> *From:* Chen, Stefanie (GBI) [mailto:stefanie.kim.c...@hp.com]
> *Sent:* Wednesday, April 04,
FIELDS TERMINATED BY '\001' is for chr(1). I'm not sure if it's decimal or
octal. But you can test it out.
From: Chen, Stefanie (GBI) [mailto:stefanie.kim.c...@hp.com]
Sent: Wednesday, April 04, 2012 1:10 PM
To: user@hive.apache.org
Subject: Field delimited by chr(28)
I have a file which has fi
I have a file which has fields delimited by chr(28) - fs. How do I specify this
in field delimited by?
Thanks,
Stefanie Chen
We saw this once when we had the wrong version of antlr in our class
path. You might double check that the version of Antlr that's being used
is that which ships with Hive.
On 4/3/12 6:32 PM, Roshan Pradeep wrote:
Hi All
I configured Apache hadoop 1.0.1 and Hive 0.8.1 in my local linux box.
Is it possible to do something like this:
CREATE EXTERNAL TABLE T
LOCATION 's3://...'
AS
SELECT ...;
I would rather not fix the schema for T so that I can easily change the
SELECT query and its underlying tables.
Because of that, I don't want to define the table first. Instead, I have to
save the
I did a test today:
select * from table where 'hello' like '%el%' limit 10;
I got 10 rows from my table
select * from table where 'HELLO' like '%el%' limit 10;
I got 0 rows from the same table.
Based on this, it would appear the like statement is case sensitive.
Coming from other RDBMs, this
