You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Josh Elser <el...@apache.org> on 2018/04/09 16:59:49 UTC

Re: Bind Params with Union throw AvaticaSqlException

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
>