[ https://issues.apache.org/jira/browse/HAWQ-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Oleksandr Diachenko updated HAWQ-1052: -------------------------------------- Description: {code} \d pxf_hive_orc_types External table "public.pxf_hive_orc_types" Column | Type | Modifiers --------+-----------------------------+----------- t1 | text | t2 | text | num1 | integer | dub1 | double precision | dec1 | numeric | tm | timestamp without time zone | r | real | bg | bigint | b | boolean | tn | smallint | sml | smallint | dt | date | vc1 | character varying(5) | c1 | character(3) | bin | bytea | Type: readable Encoding: UTF8 Format type: custom Format options: formatter 'pxfwritable_import' External location: pxf://localhost:51200/hive_orc_all_types?PROFILE=HiveORC&delimiter=^A {code} > SELECT from PXF/ORC table fails for boolean and varchar datatypes > ----------------------------------------------------------------- > > Key: HAWQ-1052 > URL: https://issues.apache.org/jira/browse/HAWQ-1052 > Project: Apache HAWQ > Issue Type: Bug > Components: PXF > Reporter: Oleksandr Diachenko > Assignee: Goden Yao > Priority: Critical > Fix For: 2.0.1.0-incubating > > > {code} > \d pxf_hive_orc_types > External table "public.pxf_hive_orc_types" > Column | Type | Modifiers > --------+-----------------------------+----------- > t1 | text | > t2 | text | > num1 | integer | > dub1 | double precision | > dec1 | numeric | > tm | timestamp without time zone | > r | real | > bg | bigint | > b | boolean | > tn | smallint | > sml | smallint | > dt | date | > vc1 | character varying(5) | > c1 | character(3) | > bin | bytea | > Type: readable > Encoding: UTF8 > Format type: custom > Format options: formatter 'pxfwritable_import' > External location: > pxf://localhost:51200/hive_orc_all_types?PROFILE=HiveORC&delimiter=^A > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)