Sarvesh N created ZEPPELIN-1580:
-----------------------------------
Summary: JDBC - SQL IN CLAUSE with Form Template does not always
Key: ZEPPELIN-1580
URL: https://issues.apache.org/jira/browse/ZEPPELIN-1580
Project: Zeppelin
Issue Type: Bug
Reporter: Sarvesh N
Below multiple checkbox statements do not work
%jdbc
select counter_date, EXTRACT(HOUR FROM counter_time) as hour, avg(value) from
sampletable.sample1 where
col1=124 and col2 in (${checkbox:fields='alpha','alpha'|'beta'}) and col3 >
${date='2016-10-01'}
and col4 in (${checkbox:fields='omega','zeta'|'delta'}) and col3='delta1'
group by 1,2 order by 1,2 asc;
The below error is thrown, the back end logs show that both the brackets have
been transformed to empty brackets with no content, how can I set some default
content, also the checkboxes are not visible
Vertica][VJDBC](4856) ERROR: Syntax error at or near ")"
class java.sql.SQLSyntaxErrorException
com.vertica.util.ServerErrorData.buildException(Unknown Source)
com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
com.vertica.jdbc.common.SStatement.executeNoParams(Unknown Source)
com.vertica.jdbc.common.SStatement.execute(Unknown Source)
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:322)
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:408)
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341)
org.apache.zeppelin.scheduler.Job.run(Job.java:176)
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
java.util.concurrent.FutureTask.run(FutureTask.java:262)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
java.lang.Thread.run(Thread.java:745)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
