setup default value of column in select statement

2012-02-02 Thread Wei Yao
Does Hive support it? In mysql, we use select 12345 as c1, how can I do that it in Hive? Thanks a lot. -- Wei Yao Engineer of PapayaMobile inc. yao...@papayamobile.com +86-13811797327

Hive alter table SerDe doesn't work in hive CDH3 for me

2012-01-04 Thread Wei Yao
ut.regex”=”[\\w]+ is [\\w]+”) 5. still doesn't work, but create new table with corrent regex works for me. select * from sample1 still shows NULL NULL NULL NULL Thanks for any supporting. -- Wei Yao Engineer of PapayaMobile inc. yao...@papayamobile.com +86-13811797327