hbutani/SQLWindowing — Issue #2: groovy syntax not recognized in the windowing cli
Author: achaubal
Created: 2012-01-30 18:05:07+00:00
State: open

hi,

I am able to make a connection from the client to the metastore service and run a hive query
hive --service windowingCli -w /tmp/windowing/com.sap.hadoop.windowing-0.0.1-SNAPSHOT-jar-with-dependencies.jar

however, when I type a query, it does not recognize the syntax,

hive> from
> partition by a1
> order by a1, a2 asc
> with rank() as r,
> select a1,a2,a8,r;
FAILED: Parse Error: line 1:5 cannot recognize input near '<' 'select' 'a1' in join source.

What am I missing?

thanks for your help

ameet