Re: can I change the default field delimiter of the hive?

2011-04-23 Thread Erix Yao
; pretty good for starters ! > > Thanks > > > On Sat, Apr 23, 2011 at 10:37 AM, Erix Yao wrote: > >> As I know, all the data exported from hive use ASCII \001 as the default >> field delimiter, and I want to change it, How can I achieve this? >> >> Thank

can I change the default field delimiter of the hive?

2011-04-22 Thread Erix Yao
As I know, all the data exported from hive use ASCII \001 as the default field delimiter, and I want to change it, How can I achieve this? Thanks -- haitao.yao@Beijing

Re: hive Authorization is not working for me

2011-04-21 Thread Erix Yao
Please Ignore this, it's my own configuration error. thanks all. 2011/4/21 Erix Yao > here's the configuration file section for default create table restriction, > as the wiki said: > > > hive.security.authorization.enabled > true > enable or disable

hive Authorization is not working for me

2011-04-21 Thread Erix Yao
here's the configuration file section for default create table restriction, as the wiki said: hive.security.authorization.enabled true enable or disable the hive client authorization I created the table named data_repository with the default hadoop user, and execute the drop table command

Re: can hive support separate namespace for temp tables?

2011-04-20 Thread Erix Yao
I can't find any documentation on the wiki, where's the doc? 2011/4/20 Edward Capriolo > On Wed, Apr 20, 2011 at 6:32 AM, Erix Yao wrote: > > > > Hi > > Some times the data analyst need to store the temp result into temp > > tables. But the data ana

can hive support separate namespace for temp tables?

2011-04-20 Thread Erix Yao
Hi Some times the data analyst need to store the temp result into temp tables. But the data analyst forgot the clear the temp tables. As the hive administrator, I suggest make the data analyst work in a separate namespace , and store the temp tables for themselves' only . For example,

index is not working for me.

2011-04-15 Thread Erix Yao
hi, I installed the hive-0.7 release for the index feature. Here's my test table schema: create table testforindex (id bigint, type int) row format delimited fields terminated by ',' lines terminated by '\n';; create index type_idx on table testforindex (type) AS 'org.apache.hadoop.hive.ql.in

Re: can I use hive dynamic partition while loading data into tables?

2011-04-15 Thread Erix Yao
ly create/overwrite partitions > that will be seen from the input query (pvs.country in the example). > > > On Apr 15, 2011, at 12:31 AM, Erix Yao wrote: > > Does this mean if I want the type field as the partition key , I will have > to split the raw data by myself and load the

Re: can I use hive dynamic partition while loading data into tables?

2011-04-15 Thread Erix Yao
tination directory. It > doesn't read the records of the input file, so it cannot do partitioning > based on record values. > > On Apr 14, 2011, at 10:52 PM, Erix Yao wrote: > > hi,all > The dynamic partition function is amazing ,but only works in insert > cla

can I use hive dynamic partition while loading data into tables?

2011-04-14 Thread Erix Yao
hi,all The dynamic partition function is amazing ,but only works in insert clause. Can I use it while loading data into table? For example: load data LOAD DATA LOCAL INPATH `/tmp/pv_2008-06-08_us.txt` INTO TABLE page_view PARTITION(date='2008-06-08', country='US', type); type is the dynam