[
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)
