[
https://issues.apache.org/jira/browse/IMPALA-12925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wenzhe Zhou updated IMPALA-12925:
---------------------------------
Description:
The data types in unit-test table alltypes do not include decimal. The data
type of column partsupp.ps_supplycost is decimal(12,2).
Create an external JDBC table to query table tpch.partsupp on remote Impala
cluster. Select statement on the JDBC table return wrong values for column
partsupp.ps_supplycost. Lots of returned values are negative.
Decimal type is listed as supported primitive data type in
DataSourceTable.java(https://github.com/apache/impala/blob/master/fe/src/main/java/org/apache/impala/catalog/DataSourceTable.java#L153).
But it seems the data type is not handled properly.
Another issue is that the decimal data type is not handled in
DataSourceScanNode.java
(https://github.com/apache/impala/blob/master/fe/src/main/java/org/apache/impala/planner/DataSourceScanNode.java#L152)
so that decimal type of predicates cannot be pushed down.
was:
The data types in unit-test table alltypes do not include decimal.
The decimal data type is not handled in DataSourceScanNode.java
(https://github.com/apache/impala/blob/master/fe/src/main/java/org/apache/impala/planner/DataSourceScanNode.java#L152),
but decimal type is listed as supported primitive data type in
DataSourceTable.java.
(https://github.com/apache/impala/blob/master/fe/src/main/java/org/apache/impala/catalog/DataSourceTable.java#L153)
> Support decimal data type for external JDBC table
> -------------------------------------------------
>
> Key: IMPALA-12925
> URL: https://issues.apache.org/jira/browse/IMPALA-12925
> Project: IMPALA
> Issue Type: Sub-task
> Components: Frontend
> Reporter: Wenzhe Zhou
> Assignee: gaurav singh
> Priority: Major
>
> The data types in unit-test table alltypes do not include decimal. The data
> type of column partsupp.ps_supplycost is decimal(12,2).
> Create an external JDBC table to query table tpch.partsupp on remote Impala
> cluster. Select statement on the JDBC table return wrong values for column
> partsupp.ps_supplycost. Lots of returned values are negative.
> Decimal type is listed as supported primitive data type in
> DataSourceTable.java(https://github.com/apache/impala/blob/master/fe/src/main/java/org/apache/impala/catalog/DataSourceTable.java#L153).
> But it seems the data type is not handled properly.
> Another issue is that the decimal data type is not handled in
> DataSourceScanNode.java
> (https://github.com/apache/impala/blob/master/fe/src/main/java/org/apache/impala/planner/DataSourceScanNode.java#L152)
> so that decimal type of predicates cannot be pushed down.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
