Re: How to change the hive.metastore.warehouse.dir ?

2011-05-18 Thread jinhang du
I make the value of 'hive.metastore.warehouse.dir" writable for all users on Hadoop. And the problem is solved. Tables can be created in my spec dir. But this operation is not safe. I don't understand the strategy of access control between hive and hdfs. Will you help me ? thx. 2011/5/18 jinhang

Map Explode

2011-05-18 Thread Quinn Gil
Is there an open source UDF to explode a Map (like explode for an array) that has key and value columns for each row? Thanks, Quinn

String Escape rules

2011-05-18 Thread Mark Meyer
Hello! I'm trying to create a table using RegexSerDe. But I'm completely lost on the string escape rules for hive: create table alerts (tstamp STRING, host STRING, service STRING, status STRING) CLUSTERED BY(host, service) SORTED BY (tstamp) INTO 1024 BUCKETS ROW FORMAT SERDE 'org.apache.hadoop.hi