[jira] [Updated] (HAWQ-1052) SELECT from PXF/ORC table fails for boolean and varchar datatypes
[
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=^A
{code}
Query fails if condition applied to boolean column:
{code}
SELECT t1, b FROM pxf_hive_orc_types WHERE b is true;
ERROR: extractPxfAttributes: unsupported node tag 330, unable to extract
attribute from qualifier (pxffilters.c:665) (seg4 localhost:4 pid=73027)
DETAIL: External table pxf_hive_orc_types
{code}
Query returns empty result when condition applied to varchar column but it's
not in select list:
{code}
SELECT t1 FROM pxf_hive_orc_types WHERE vc1 = 'abcd';
t1
(0 rows)
{code}
was:
{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=^A
{code}
Query fails if condition applied to boolean column:
{code}
SELECT t1, b FROM pxf_hive_orc_types WHERE b is true;
ERROR: extractPxfAttributes: unsupported node tag 330, unable to extract
attribute from qualifier (pxffilters.c:665) (seg4 localhost:4 pid=73027)
DETAIL: External table pxf_hive_orc_types
{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=^A
> {code}
> Query fails if condition applied to boolean column:
> {code}
> SELECT t1, b FROM pxf_hive_orc_types WHERE b is true;
> ERROR: extractPxfAttributes: unsupported node tag 330, unable to extract
> attribute from qualifier (pxffilters.c:665) (seg4 localhost:4 pid=73027)
> DETAIL: External table pxf_hive_orc_types
> {code}
> Query returns empty result when condition applied to varchar column but it's
> not in select list:
> {code}
> SELECT t1 FROM
[jira] [Updated] (HAWQ-1052) SELECT from PXF/ORC table fails for boolean and varchar datatypes
[
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=^A
{code}
Query fails if condition applied to boolean column:
{code}
SELECT t1, b FROM pxf_hive_orc_types WHERE b is true;
ERROR: extractPxfAttributes: unsupported node tag 330, unable to extract
attribute from qualifier (pxffilters.c:665) (seg4 localhost:4 pid=73027)
DETAIL: External table pxf_hive_orc_types
{code}
was:
{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=^A
{code}
{code}
SELECT t1, b FROM pxf_hive_orc_types WHERE b is true;
{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=^A
> {code}
> Query fails if condition applied to boolean column:
> {code}
> SELECT t1, b FROM pxf_hive_orc_types WHERE b is true;
> ERROR: extractPxfAttributes: unsupported node tag 330, unable to extract
> attribute from qualifier (pxffilters.c:665) (seg4 localhost:4 pid=73027)
> DETAIL: External table pxf_hive_orc_types
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HAWQ-1052) SELECT from PXF/ORC table fails for boolean and varchar datatypes
[
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=^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=^A
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HAWQ-1052) SELECT from PXF/ORC table fails for boolean and varchar datatypes
[
https://issues.apache.org/jira/browse/HAWQ-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Goden Yao updated HAWQ-1052:
Fix Version/s: (was: backlog)
2.0.1.0-incubating
> 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=^A
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HAWQ-1052) SELECT from PXF/ORC table fails for boolean and varchar datatypes
[ https://issues.apache.org/jira/browse/HAWQ-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oleksandr Diachenko updated HAWQ-1052: -- Fix Version/s: backlog > 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: backlog > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-1052) SELECT from PXF/ORC table fails for boolean and varchar datatypes
[ https://issues.apache.org/jira/browse/HAWQ-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Goden Yao updated HAWQ-1052: Priority: Critical (was: Major) > 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: backlog > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
