I think this may be a limitation of the Hive version that Drill embeds (and is used when querying hive tables). Can you try just querying the parquet files through the dfs plugin directly? Drill (not through Hive) should be able to handle these datatypes without issue.
thanks, Jacques -- Jacques Nadeau CTO and Co-Founder, Dremio On Wed, Nov 18, 2015 at 10:34 PM, Wangchangchun (A) < [email protected]> wrote: > Hi, everyone, can anybody help to answer me a question. > > I have used sparksql to create some table of parquet format. > And then I configured hive Storage Plugins, > But when I use drill do query on this table, some error occurs: > > Error: SYSTEM ERROR: UnsupportedOperationException: Parquet does not > support date. See HIVE-6384 > Fragment 0:0 > > The drill version is 1.2.0. > So, now, drill don't support some types such as "date", isn't it? > > SQL: > select count(*) from call_center; > > create external table call_center > ( > cc_call_center_sk int , > cc_call_center_id string , > cc_rec_start_date date , > cc_rec_end_date date , > cc_closed_date_sk int , > cc_open_date_sk int , > cc_name string , > cc_class string , > cc_employees int , > cc_sq_ft int , > cc_hours string , > cc_manager string , > cc_mkt_id int , > cc_mkt_class string , > cc_mkt_desc string , > cc_market_manager string , > cc_division int , > cc_division_name string , > cc_company int , > cc_company_name string , > cc_street_number string , > cc_street_name string , > cc_street_type string , > cc_suite_number string , > cc_city string , > cc_county string , > cc_state string , > cc_zip string , > cc_country string , > cc_gmt_offset float , > cc_tax_percentage float > )row format delimited fields terminated by "|" > STORED AS PARQUET > location '/user/wf/warehouse/tpcds_500g_paquet.db/call_center' ; > >
