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)