You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Anton Gozhiy (JIRA)" <ji...@apache.org> on 2019/01/28 13:46:00 UTC
[jira] [Created] (DRILL-7010) Wrong result is returned if filtering
by a decimal column using old parquet data with old metadata file.
Anton Gozhiy created DRILL-7010:
-----------------------------------
Summary: Wrong result is returned if filtering by a decimal column using old parquet data with old metadata file.
Key: DRILL-7010
URL: https://issues.apache.org/jira/browse/DRILL-7010
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.15.0
Reporter: Anton Gozhiy
Attachments: partsupp_old.zip, supplier_old.zip
*Prerequisites:*
- The data was generated by Drill 1.14.0-SNAPSHOT (commit 4c4953bcab4886be14fc9b7f95a77caa86a7629f). See attachment.
- set store.parquet.reader.strings_signed_min_max = "true"
*Query #1:*
{code:sql}
select *
from dfs.tmp.`supplier_old`
where not s_acctbal > -900
{code}
*Expected result:*
{noformat}
65 Supplier#000000065 BsAnHUmSFArppKrM 22 32-444-835-2434 -963.79 l ideas wake carefully around the regular packages. furiously ruthless pinto bea
65 Supplier#000000065 BsAnHUmSFArppKrM 22 32-444-835-2434 -963.79 l ideas wake carefully around the regular packages. furiously ruthless pinto bea
65 Supplier#000000065 BsAnHUmSFArppKrM 22 32-444-835-2434 -963.79 l ideas wake carefully around the regular packages. furiously ruthless pinto bea
22 Supplier#000000022 okiiQFk 8lm6EVX6Q0,bEcO 4 14-144-830-2814 -966.20 ironically among the deposits. closely expre
22 Supplier#000000022 okiiQFk 8lm6EVX6Q0,bEcO 4 14-144-830-2814 -966.20 ironically among the deposits. closely expre
22 Supplier#000000022 okiiQFk 8lm6EVX6Q0,bEcO 4 14-144-830-2814 -966.20 ironically among the deposits. closely expre
{noformat}
*Actual result:*
{noformat}
65 Supplier#000000065 BsAnHUmSFArppKrM 22 32-444-835-2434 -963.79 l ideas wake carefully around the regular packages. furiously ruthless pinto bea
65 Supplier#000000065 BsAnHUmSFArppKrM 22 32-444-835-2434 -963.79 l ideas wake carefully around the regular packages. furiously ruthless pinto bea
65 Supplier#000000065 BsAnHUmSFArppKrM 22 32-444-835-2434 -963.79 l ideas wake carefully around the regular packages. furiously ruthless pinto bea
{noformat}
*Query #2*
{code:sql}
select ps_availqty, ps_supplycost, ps_comment
from dfs.tmp.`partsupp_old`
where ps_supplycost > 999.9
{code}
*Expected result:*
{noformat}
5136 999.92 lets grow carefully. slyly silent ideas about the foxes nag blithely ironi
8324 999.93 ly final instructions. closely final deposits nag furiously alongside of the furiously dogged theodolites. blithely unusual theodolites are furi
5070 999.99 ironic, special deposits. carefully final deposits haggle fluffily. furiously final foxes use furiously furiously ironic accounts. package
6915 999.95 fluffily unusual packages doubt even, regular requests. ironic requests detect carefully blithely silen
1761 999.95 lyly about the permanently ironic instructions. carefully ironic pinto beans
2120 999.97 ts haggle blithely about the pending, regular ideas! e
1615 999.92 riously ironic foxes detect fluffily across the regular packages
{noformat}
*Actual result:*
No data is returned.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)