Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Duplicate
-
0.8.0
-
None
Description
This bug looks suspiciously similar to drill-2220, but assert is different + wrong result.
Decimal9 : failure to read from the table
0: jdbc:drill:schema=dfs> select cast('1.2' as decimal(8,2)) from `test.json`; +------------+ | EXPR$0 | +------------+ | 1.20 | | 1.20 | | 1.20 | | 1.20 | | 1.20 | | 1.20 | +------------+ 6 rows selected (0.081 seconds) 0: jdbc:drill:schema=dfs> create table temp(c1) as select cast('1.2' as decimal(8,2)) from `test.json`; +------------+---------------------------+ | Fragment | Number of records written | +------------+---------------------------+ | 0_0 | 6 | +------------+---------------------------+ 1 row selected (0.193 seconds) 0: jdbc:drill:schema=dfs> select * from temp; Query failed: RemoteRpcException: Failure while running fragment., org.apache.drill.exec.vector.Decimal9Vector cannot be cast to org.apache.drill.exec.vector.IntVector [ 33d801e0-a1d4-4999-9aac-e35f445018bb on atsqa4-133.qa.lab:31010 ] [ 33d801e0-a1d4-4999-9aac-e35f445018bb on atsqa4-133.qa.lab:31010 ] Error: exception while executing query: Failure while executing query. (state=,code=0)
Decimal18 : failure to read from the table
0: jdbc:drill:schema=dfs> select cast('1.2' as decimal(18,2)) from `test.json`; +------------+ | EXPR$0 | +------------+ | 1.20 | | 1.20 | | 1.20 | | 1.20 | | 1.20 | | 1.20 | +------------+ 6 rows selected (0.064 seconds) 0: jdbc:drill:schema=dfs> create table temp1(c1) as select cast('1.2' as decimal(18,2)) from `test.json`; +------------+---------------------------+ | Fragment | Number of records written | +------------+---------------------------+ | 0_0 | 6 | +------------+---------------------------+ 1 row selected (0.257 seconds) 0: jdbc:drill:schema=dfs> select * from temp1; Query failed: RemoteRpcException: Failure while running fragment., org.apache.drill.exec.vector.Decimal18Vector cannot be cast to org.apache.drill.exec.vector.BigIntVector [ 5a23c757-9723-43cc-874b-18aaf62640a4 on atsqa4-133.qa.lab:31010 ] [ 5a23c757-9723-43cc-874b-18aaf62640a4 on atsqa4-133.qa.lab:31010 ] Error: exception while executing query: Failure while executing query. (state=,code=0)
Decimal28 : wrong result
0: jdbc:drill:schema=dfs> create table temp2(c1) as select cast('1.2' as decimal(28,2)) from `test.json`; +------------+---------------------------+ | Fragment | Number of records written | +------------+---------------------------+ | 0_0 | 6 | +------------+---------------------------+ 1 row selected (0.194 seconds) 0: jdbc:drill:schema=dfs> select * from temp2; +------------+ | c1 | +------------+ | 12000000.00 | | 12000000.00 | | 12000000.00 | | 12000000.00 | | 12000000.00 | | 12000000.00 | +------------+ 6 rows selected (0.057 seconds)
Decimal38: wrong result
0: jdbc:drill:schema=dfs> create table temp4(c1) as select cast('1.2' as decimal(38,2)) from `test.json`; +------------+---------------------------+ | Fragment | Number of records written | +------------+---------------------------+ | 0_0 | 6 | +------------+---------------------------+ 1 row selected (0.214 seconds) 0: jdbc:drill:schema=dfs> select * from temp4; +------------+ | c1 | +------------+ | 12000000.00 | | 12000000.00 | | 12000000.00 | | 12000000.00 | | 12000000.00 | | 12000000.00 | +------------+ 6 rows selected (0.048 seconds)
Attachments
Issue Links
- duplicates
-
DRILL-2220 Complex reader unable to read FIXED_LEN_BYTE_ARRAY types in parquet file
- Resolved
-
DRILL-2253 Vectorized Parquet reader fails to read correctly against RLE Dictionary encoded DATE column
- Resolved