[ https://issues.apache.org/jira/browse/DRILL-2458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jinfeng Ni updated DRILL-2458: ------------------------------ Attachment: 0001-DRILL-2458-Ensure-no-unwanted-columns-are-added-to-C.patch > Extra hash column added when running CTAS with order by > ------------------------------------------------------- > > Key: DRILL-2458 > URL: https://issues.apache.org/jira/browse/DRILL-2458 > Project: Apache Drill > Issue Type: Bug > Reporter: Steven Phillips > Assignee: Jinfeng Ni > Attachments: > 0001-DRILL-2458-Ensure-no-unwanted-columns-are-added-to-C.patch > > > I created the table via the command: > {code:sql} > create table dfs.tmp.lineitem_sort as select * from > dfs.`/drill/SF10/lineitem` order by l_extendedprice desc > {code} > This resulted in an extra column when reading the data back: > {code} > 0: jdbc:drill:> select * from `lineitem_sort/0_0_0.parquet` limit 1; > +---------------------------+------------+--------------+------------+-----------------+--------------+--------------+------------+------------+------------+---------------+--------------+------------+----------------+------------+------------+------------+------------------+ > | E_X_P_R_H_A_S_H_F_I_E_L_D | L_COMMENT | L_COMMITDATE | L_DISCOUNT | > L_EXTENDEDPRICE | L_LINENUMBER | L_LINESTATUS | L_ORDERKEY | L_PARTKEY | > L_QUANTITY | L_RECEIPTDATE | L_RETURNFLAG | L_SHIPDATE | L_SHIPINSTRUCT | > L_SHIPMODE | L_SUPPKEY | L_TAX | l_extendedprice0 | > +---------------------------+------------+--------------+------------+-----------------+--------------+--------------+------------+------------+------------+---------------+--------------+------------+----------------+------------+------------+------------+------------------+ > | -1909175176 | [B@187a06b6 | [B@734ea347 | 0.02 | > 104949.5 | 2 | [B@2fc1c575 | 16734176 | 199999 | > 50.0 | [B@5a8a9cd1 | [B@423d8bc7 | [B@56a3d7ca | [B@1eac3b36 | > [B@3d6365f5 | 50002 | 0.05 | 104949.5 | > +---------------------------+------------+--------------+------------+-----------------+--------------+--------------+------------+------------+------------+---------------+--------------+------------+----------------+------------+------------+------------+------------------+ > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)