[jira] [Created] (HAWQ-335) Cannot query parquet hive table through PXF

["zharui (JIRA)" <ji...@apache.org>]

zharui created HAWQ-335:
---------------------------

             Summary: Cannot query parquet hive table through PXF
                 Key: HAWQ-335
                 URL: https://issues.apache.org/jira/browse/HAWQ-335
             Project: Apache HAWQ
          Issue Type: Bug
          Components: PXF
            Reporter: zharui
            Assignee: Goden Yao


I created an external table in hawq that exist in hive with parquet format, but I cannot query this table in hawq. The segment processes are idle and nothing happened.

The clause of creating external hive parquet table as below:

create external table zc_parquet800_partitioned (start_time bigint,cdr_id int,"offset" int,calling varchar(255),imsi varchar(255),user_ip int,tmsi int,p_tmsi int,imei varchar(255),mcc int,mnc int,lac int,rac int,cell_id int,bsc_ip int,opc int,dpc int,sgsn_sg_ip int,ggsn_sg_ip int,sgsn_data_ip int,ggsn_data_ip int,apn varchar(255),rat int,service_type smallint,service_group smallint,up_packets int,down_packets int,up_bytes int,down_bytes int,up_speed real,down_speed real,trans_time int,first_time timestamp,end_time timestamp,is_end int,user_port int,proto_type int,dest_ip int,dest_port int,paging_count smallint,assignment_count smallint,joiner_id varchar(255),operation smallint,country smallint,loc_prov smallint,loc_city smallint,roam_prov smallint,roam_city smallint,sgsn varchar(255),bsc_rnc varchar(255),terminal_fac smallint,terminal_type int,terminal_class smallint,roaming_type smallint,host_operator smallint,net_type smallint, time int, calling_hash int) LOCATION ('pxf://ws01.mzhen.cn:51200/zc_parquet800_partitioned?PROFILE=Hive') FORMAT 'custom' (formatter='pxfwritable_import');





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