phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sumanta Gh <sumanta...@tcs.com>
Subject Exception during executing query on dynamic column using JDBC
Date Mon, 31 Mar 2014 12:40:39 GMT
Hi 
When I run this query [1] from sqlline, it works fine.
But using JDBC prepared statements, I get following error [2].
The column "speed" is a dynamic column and I want to filter rows based on 
it's value.

[1] SELECT * FROM test ("speed" DECIMAL) WHERE "speed" < 90;
[2] Caused by: org.springframework.dao.DataIntegrityViolationException: 
PreparedStatementCallback; SQL [SELECT * FROM test("speed" DECIMAL) WHERE 
"speed"<? ]; ERROR 203 (22005): Type mismatch. DECIMAL and CHAR for 
com.salesforce.phoenix.parse.LessThanParseNode[speed, :1]; nested 
exception is com.salesforce.phoenix.schema.TypeMismatchException: ERROR 
203 (22005): Type mismatch. DECIMAL and CHAR for 
com.salesforce.phoenix.parse.LessThanParseNode[speed, :1]
        at 
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(
SQLStateSQLExceptionTranslator.java:100)
        at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(
AbstractFallbackSQLExceptionTranslator.java:73)
        at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(
AbstractFallbackSQLExceptionTranslator.java:81)
        at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(
AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.core.JdbcTemplate.execute(
JdbcTemplate.java:658)
        at org.springframework.jdbc.core.JdbcTemplate.query(
JdbcTemplate.java:693)
        at org.springframework.jdbc.core.JdbcTemplate.query(
JdbcTemplate.java:725)
        at org.springframework.jdbc.core.JdbcTemplate.query(
JdbcTemplate.java:735)
        at org.springframework.jdbc.core.JdbcTemplate.query(
JdbcTemplate.java:785)
        at com.ripsac.sos.dao.hbase.impl.ObservationDAOHbaseImpl.findAll(
ObservationDAOHbaseImpl.java:72)
        ... 28 more
Caused by: com.salesforce.phoenix.schema.TypeMismatchException: ERROR 203 
(22005): Type mismatch. DECIMAL and CHAR for 
com.salesforce.phoenix.parse.LessThanParseNode[speed, :1]
        at 
com.salesforce.phoenix.compile.ExpressionCompiler.checkComparability(
ExpressionCompiler.java:156)
        at 
com.salesforce.phoenix.compile.ExpressionCompiler.checkComparability(
ExpressionCompiler.java:190)
        at com.salesforce.phoenix.compile.ExpressionCompiler.visitLeave(
ExpressionCompiler.java:204)

Regards
Sumanta Ghosh
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you



Mime
View raw message