phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lew Jackman" <lew9...@netzero.net>
Subject Bind Params with Union throw AvaticaSqlException
Date Wed, 04 Apr 2018 02:21:07 GMT
We are getting org.apache.calcite.avatica.AvaticaSqlException when using bind parameters in
a SQL select statement that contains a UNION ALL. Queries without a UNION ALL work fine. 

This is Phoenix 4.9

For example:
select a, b, c from TABLE_1 where a = ?
union all
select a, b, c from TABLE_2 where a = ?

Exception:
org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : while preparing SQL: ...
at org.apache.calcite.avatica.Helper.createException(Helper.java:53)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:329)
at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:165)
____________________________________________________________
Buckingham Confirms Unfortunate News
risingstarnewspaper.com
http://thirdpartyoffers.netzero.net/TGL3231/5ac436cae7d1d36ca7070st02vuc
Mime
View raw message