Re: [SPARK-SQL] How to pass parameter when running hql script using cli?

2015-03-08 Thread James
Hi, It still don't work. Is there any success instruction about how to pass a date to a hql script? Alcaid 2015-03-07 2:43 GMT+08:00 Zhan Zhang : > Do you mean “--hiveConf” (two dash) , instead of -hiveconf (one dash) > > Thanks. > > Zhan Zhang > > On Mar 6, 2015, at 4:20 AM, James wrote: > >

Re: [SPARK-SQL] How to pass parameter when running hql script using cli?

2015-03-06 Thread Zhan Zhang
Do you mean “--hiveConf” (two dash) , instead of -hiveconf (one dash) Thanks. Zhan Zhang On Mar 6, 2015, at 4:20 AM, James wrote: > Hello, > > I want to execute a hql script through `spark-sql` command, my script > contains: > > ``` > ALTER TABLE xxx > DROP PARTITION (date_key = ${hiveco

[SPARK-SQL] How to pass parameter when running hql script using cli?

2015-03-06 Thread James
Hello, I want to execute a hql script through `spark-sql` command, my script contains: ``` ALTER TABLE xxx DROP PARTITION (date_key = ${hiveconf:CUR_DATE}); ``` when I execute ``` spark-sql -f script.hql -hiveconf CUR_DATE=20150119 ``` It throws an error like ``` cannot recognize input near '$