phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Liew (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate
Date Wed, 23 Dec 2015 20:51:46 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15070175#comment-15070175
] 

Kevin Liew edited comment on PHOENIX-2314 at 12/23/15 8:51 PM:
---------------------------------------------------------------

Sorry I was mistaken again, the HDP server is not the one I'm using right now. I was previously
using the HDP Sandbox VM before switching to Docker images with manual installation through
the Dockerfile, and I'm in the process of building Docker images with Ambari and HDP so I
got a bit confused.  :) 

Atm, I'm still using a Docker container with HBase and Phoenix installed during the image
build

I will try again after replacing those jars.


was (Author: kliew):
Sorry I was mistaken again, the HDP server is not the one I'm using right now. I'm using a
Docker container with HBase and Phoenix installed during the image build


I will try again after replacing those jars.

> Cannot prepare parameterized statement with a 'like' predicate
> --------------------------------------------------------------
>
>                 Key: PHOENIX-2314
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2314
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.5.2
>         Environment: Using Fiddler or cURL to communicate with a Phoenix 4.5.2 queryserver
using Avatica wire protocol
>            Reporter: Kevin Liew
>              Labels: avatica, phoenix
>
> *POST*
> {noformat}
> request: { "request":"prepare", "connectionId":"1646a1b9-334e-4a21-ade8-47c3d0c8e5a3",
"sql":"select * from emp where first_name like ?", "maxRowCount":-1 }
> Host: 192.168.203.156:8765
> Content-Length: 0
> {noformat}
> _select * from emp where first_name like ?_
> *RESPONSE*
> {noformat}
> HTTP/1.1 500 org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type
mismatch. BOOLEAN for null
> Date: Wed, 07 Oct 2015 22:42:26 GMT
> Cache-Control: must-revalidate,no-cache,no-store
> Content-Type: text/html; charset=ISO-8859-1
> Content-Length: 368
> Connection: close
> Server: Jetty(9.2.z-SNAPSHOT)
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
> <title>Error 500 </title>
> </head>
> <body>
> <h2>HTTP ERROR: 500</h2>
> <p>Problem accessing /. Reason:
> <pre>    org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type
mismatch. BOOLEAN for null</pre></p>
> <hr /><i><small>Powered by Jetty://</small></i>
> </body>
> </html>
> {noformat}
> _org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type mismatch. BOOLEAN
for null_



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message