Hi Lew,
I believe the snippet of the stack trace you have provided isn't telling
us anything other than that the real PhoenixDriver code threw an error
(Avatica/PQS are just doing pass-through to the real PhoenixDriver inside).
Can you please look closer at the bottom of the stack trace to see if
you missed something in the first copy-paste?
On 4/3/18 10:21 PM, Lew Jackman wrote:
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
