[ https://issues.apache.org/jira/browse/DRILL-4989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zelaine Fong reassigned DRILL-4989: ----------------------------------- Assignee: Arina Ielchiieva (was: Vitalii Diravka) Assigning to [~arina] to review. > Fix TestParquetWriter.testImpalaParquetBinaryAsTimeStamp_DictChange > ------------------------------------------------------------------- > > Key: DRILL-4989 > URL: https://issues.apache.org/jira/browse/DRILL-4989 > Project: Apache Drill > Issue Type: Bug > Reporter: Arina Ielchiieva > Assignee: Arina Ielchiieva > Fix For: 1.9.0 > > > Test TestParquetWriter.testImpalaParquetBinaryAsTimeStamp_DictChange expects > sorted output but query does not include order by clause. This causes unit > test to fail sometimes: > {noformat} > Expected Records near verification failure: > Record Number: 0 { `int96_ts` : 1970-01-01T00:00:01.000Z, } > Record Number: 1 { `int96_ts` : 1971-01-01T00:00:01.000Z, } > Record Number: 2 { `int96_ts` : 1972-01-01T00:00:01.000Z, } > Record Number: 3 { `int96_ts` : 1973-01-01T00:00:01.000Z, } > Record Number: 4 { `int96_ts` : 1974-01-01T00:00:01.000Z, } > Record Number: 5 { `int96_ts` : 2010-01-01T00:00:01.000Z, } > Record Number: 6 { `int96_ts` : 2011-01-01T00:00:01.000Z, } > Record Number: 7 { `int96_ts` : 2012-01-01T00:00:01.000Z, } > Record Number: 8 { `int96_ts` : 2013-01-01T00:00:01.000Z, } > Record Number: 9 { `int96_ts` : 2014-01-01T00:00:01.000Z, } > Actual Records near verification failure: > Record Number: 0 { `int96_ts` : 2010-01-01T00:00:01.000Z, } > Record Number: 1 { `int96_ts` : 2011-01-01T00:00:01.000Z, } > Record Number: 2 { `int96_ts` : 2012-01-01T00:00:01.000Z, } > Record Number: 3 { `int96_ts` : 2013-01-01T00:00:01.000Z, } > Record Number: 4 { `int96_ts` : 2014-01-01T00:00:01.000Z, } > Record Number: 5 { `int96_ts` : 2015-01-01T00:00:01.000Z, } > Record Number: 6 { `int96_ts` : 2016-01-01T00:00:01.000Z, } > Record Number: 7 { `int96_ts` : 1970-01-01T00:00:01.000Z, } > Record Number: 8 { `int96_ts` : 1971-01-01T00:00:01.000Z, } > Record Number: 9 { `int96_ts` : 1972-01-01T00:00:01.000Z, } > {noformat} > To fix add order by in select statement: > {noformat} > select int96_ts from dfs_test.`%s/parquet/int96_dict_change` order by int96_ts > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)