[
https://issues.apache.org/jira/browse/CALCITE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alessandro Solimando updated CALCITE-3465:
------------------------------------------
Description:
Currently cassandra-adapter covers only part of the [data types available in
Cassandra 3.x|[http://cassandra.apache.org/doc/latest/cql/types.html]], the
scope of the ticket is to extend the coverage and support all data types.
Current status:
||CQL Data Type||SQL Data Type||Java Class||Supported||
|custom|ANY|N/A|N|
|duration|ANY|N/A|N|
|uuid|CHAR|java.lang.String|Y|
|timeuuid|CHAR|java.lang.String|Y|
|ascii|VARCHAR|java.lang.String|Y|
|text|VARCHAR|java.lang.String|Y|
|varchar|VARCHAR|java.lang.String|Y|
|int (cint)|INTEGER|int|Y|
|varint|INTEGER|int|Y|
|bigint|BIGINT|long|Y|
|double (cdouble)|DOUBLE|double|Y|
|float (cfloat)|REAL (was DOUBLE)|float|Y|
|decimal|DOUBLE|N/A|Y|
|blob|VARBINARY|N/A|N|
|boolean|BOOLEAN|N/A|N|
|counter|INTEGER|N/A|N|
|date|DATE|N/A|N|
|inet|ANY|N/A|N|
|list|ARRAY|N/A|N|
|map|MAP|N/A|N|
|set|MULTISET|N/A|N|
|smallint|SMALLINT|N/A|N|
|time|TIME|N/A|N|
|timestamp|TIMESTAMP|N/A|N|
|tinyint|TINYINT|N/A|N|
|tuple|ARRAY|N/A|N|
|udt|ANY|N/A|N|
Second column is derived from
_org.apache.calcite.adapter.cassandra.CassandraSchema.getRelDataType(...),_
third column from _org.apache.calcite.adapter.cassandra.currentRowField(...)._
was:
Currently cassandra-adapter covers only part of the [data types available in
Cassandra
3.x|[https://docs.datastax.com/en/archived/cql/3.3/cql/cql_reference/cql_data_types_c.html]],
the scope of the ticket is to extend the coverage and support all data types.
Current status:
||CQL Data Type||SQL Data Type||Java Class||Supported||
|uuid|CHAR|java.lang.String|Y|
|timeuuid|CHAR|java.lang.String|Y|
|ascii|VARCHAR|java.lang.String|Y|
|text|VARCHAR|java.lang.String|Y|
|varchar|VARCHAR|java.lang.String|Y|
|int (cint)|INTEGER|int|Y|
|varint|INTEGER|int|Y|
|bigint|BIGINT|long|Y|
|double (cdouble)|DOUBLE|double|Y|
|float (cfloat)|DOUBLE (should be REAL?)|float|Y|
|decimal|DOUBLE|N/A|Y|
|blob|VARBINARY|N/A|N|
|boolean|BOOLEAN|N/A|N|
|counter|INTEGER|N/A|N|
|date|DATE|N/A|N|
|frozen|?|N/A|N|
|inet|?|N/A|N|
|list|ARRAY?|N/A|N|
|map|MAP|N/A|N|
|set|?|N/A|N|
|smallint|SMALLINT|N/A|N|
|time|TIME?|N/A|N|
|timestamp|TIMESTAMP|N/A|N|
|tinyint|TINYINT|N/A|N|
|tuple|ARRAY?|N/A|N|
Second column is derived from
_org.apache.calcite.adapter.cassandra.CassandraSchema.getRelDataType(...),_
third column from _org.apache.calcite.adapter.cassandra.currentRowField(...)._
> Cover Cassandra 3.x data types
> ------------------------------
>
> Key: CALCITE-3465
> URL: https://issues.apache.org/jira/browse/CALCITE-3465
> Project: Calcite
> Issue Type: Improvement
> Components: cassandra-adapter
> Affects Versions: 1.21.0
> Reporter: Alessandro Solimando
> Priority: Major
>
> Currently cassandra-adapter covers only part of the [data types available in
> Cassandra 3.x|[http://cassandra.apache.org/doc/latest/cql/types.html]], the
> scope of the ticket is to extend the coverage and support all data types.
> Current status:
> ||CQL Data Type||SQL Data Type||Java Class||Supported||
> |custom|ANY|N/A|N|
> |duration|ANY|N/A|N|
> |uuid|CHAR|java.lang.String|Y|
> |timeuuid|CHAR|java.lang.String|Y|
> |ascii|VARCHAR|java.lang.String|Y|
> |text|VARCHAR|java.lang.String|Y|
> |varchar|VARCHAR|java.lang.String|Y|
> |int (cint)|INTEGER|int|Y|
> |varint|INTEGER|int|Y|
> |bigint|BIGINT|long|Y|
> |double (cdouble)|DOUBLE|double|Y|
> |float (cfloat)|REAL (was DOUBLE)|float|Y|
> |decimal|DOUBLE|N/A|Y|
> |blob|VARBINARY|N/A|N|
> |boolean|BOOLEAN|N/A|N|
> |counter|INTEGER|N/A|N|
> |date|DATE|N/A|N|
> |inet|ANY|N/A|N|
> |list|ARRAY|N/A|N|
> |map|MAP|N/A|N|
> |set|MULTISET|N/A|N|
> |smallint|SMALLINT|N/A|N|
> |time|TIME|N/A|N|
> |timestamp|TIMESTAMP|N/A|N|
> |tinyint|TINYINT|N/A|N|
> |tuple|ARRAY|N/A|N|
> |udt|ANY|N/A|N|
> Second column is derived from
> _org.apache.calcite.adapter.cassandra.CassandraSchema.getRelDataType(...),_
> third column from
> _org.apache.calcite.adapter.cassandra.currentRowField(...)._
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
