hive case and group-by statement

2011-12-04 Thread Mapred Learn
Hi, I have a following smaple query: select A, CASE WHEN B IN(1,2) THEN 'Type A' ELSE 'Type B' END AS B, C from table_a groupby A, B, C; But when i run this query, it gives error: FAILED: Error in semantic analysis: Line 95:0 Invalid table alias or column reference entity This error is from B

Attaching YourKit profiler with Hive

2011-12-04 Thread john smith
Hi folks, Can we get a shared license key for yourkit and use it with Hive project? The wiki page has no information about this. Can any dev help me in this regard? Thanks, jS