You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org> on 2014/11/17 23:11:35 UTC

[jira] [Created] (DRILL-1739) Parquet complex reader does * if no matching columns are found

Ramana Inukonda Nagaraj created DRILL-1739:
----------------------------------------------

             Summary: Parquet complex reader does * if no matching columns are found
                 Key: DRILL-1739
                 URL: https://issues.apache.org/jira/browse/DRILL-1739
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Parquet
            Reporter: Ramana Inukonda Nagaraj
            Priority: Blocker


0: jdbc:drill:> select c_customer_sk from `0_0_0.parquet` limit 1;
+---------------+
| c_customer_sk |
+---------------+
| 1             |
+---------------+

When a non existent column is queried- Drill returns all columns like a * operation

0: jdbc:drill:> select ramana from `0_0_0.parquet` limit 1;
+---------------+---------------+--------------------+--------------------+-------------------+------------------------+-----------------------+--------------+--------------+-------------+-----------------------+-------------+---------------+--------------+-----------------+------------+-----------------+--------------------+
| c_customer_sk | c_customer_id | c_current_cdemo_sk | c_current_hdemo_sk | c_current_addr_sk | c_first_shipto_date_sk | c_first_sales_date_sk | c_salutation | c_first_name | c_last_name | c_preferred_cust_flag | c_birth_day | c_birth_month | c_birth_year | c_birth_country |  c_login   | c_email_address | c_last_review_date |
+---------------+---------------+--------------------+--------------------+-------------------+------------------------+-----------------------+--------------+--------------+-------------+-----------------------+-------------+---------------+--------------+-----------------+------------+-----------------+--------------------+
| 1             | AAAAAAAABAAAAAAA | 980124             | 7135               | 32946             | 2452238                | 2452208               | Mr.          | Javier       | Lewis       | Y                     | 9           | 12            | 1936         | CHILE           | null       | Javier.Lewis@VFAxlnZEvOx.org | 2452508            |
+---------------+---------------+--------------------+--------------------+-------------------+------------------------+-----------------------+--------------+--------------+-------------+-----------------------+-------------+---------------+--------------+-----------------+------------+-----------------+--------------------+
1 row selected (0.404 seconds)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)