[
https://issues.apache.org/jira/browse/HAWQ-1461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Diachenko updated HAWQ-1461:
--------------------------------------
Description:
h3. User didn't pass interval type, query fails with NPE:
{code}
CREATE EXTERNAL TABLE pxf_jdbc_multiple_fragments_by_date (t1 text, t2
text, num1 int, dub1 double precision, dec1 numeric, tm timestamp, r real,
bg bigint, b boolean, tn smallint, sml smallint, dt date, vc1 varchar(5), c1
char(3), bin bytea) LOCATION
(E'pxf://127.0.0.1:51200/hawq_types?PROFILE=Jdbc&JDBC_DRIVER=org.postgresql.Driver&DB_URL=jdbc:postgresql:pxfautomation//localhost:5432&PARTITION_BY=dt:date&RANGE=2015-03-06:2015-03-20&INTERVAL=1&USER=adiachenko')
FORMAT 'CUSTOM' (formatter='pxfwritable_import');
{code}
Actual behavior:
{code}
select * from pxf_jdbc_multiple_fragments_by_date;
ERROR: remote component error (500) from '127.0.0.1:51200': type Exception
report message description The server encountered an internal error
that prevented it from fulfilling this request. exception
java.lang.NullPointerException (libchurl.c:897)
{code}
Expected behavior: meaningful and user-friendly message.
h3. User didn't pass interval:
{code}
CREATE EXTERNAL TABLE pxf_jdbc_multiple_fragments_by_date (t1 text, t2
text, num1 int, dub1 double precision, dec1 numeric, tm timestamp, r real,
bg bigint, b boolean, tn smallint, sml smallint, dt date, vc1 varchar(5), c1
char(3), bin bytea) LOCATION
(E'pxf://127.0.0.1:51200/hawq_types?PROFILE=Jdbc&JDBC_DRIVER=org.postgresql.Driver&DB_URL=jdbc:postgresql:pxfautomation//localhost:5432&PARTITION_BY=dt:date&RANGE=2015-03-06:2015-03-20&USER=adiachenko')
FORMAT 'CUSTOM' (formatter='pxfwritable_import');
{code}
Actual behavior:
{code}
ERROR: remote component error (500) from '127.0.0.1:51200': type Exception
report message description The server encountered an internal error
that prevented it from fulfilling this request. exception
java.lang.NullPointerException (libchurl.c:897)
{code}
was:
# User didn't pass interval type, query fails with NPE:
{code}
CREATE EXTERNAL TABLE pxf_jdbc_multiple_fragments_by_date (t1 text, t2
text, num1 int, dub1 double precision, dec1 numeric, tm timestamp, r real,
bg bigint, b boolean, tn smallint, sml smallint, dt date, vc1 varchar(5), c1
char(3), bin bytea) LOCATION
(E'pxf://127.0.0.1:51200/hawq_types?PROFILE=Jdbc&JDBC_DRIVER=org.postgresql.Driver&DB_URL=jdbc:postgresql:pxfautomation//localhost:5432&PARTITION_BY=dt:date&RANGE=2015-03-06:2015-03-20&INTERVAL=1&USER=adiachenko')
FORMAT 'CUSTOM' (formatter='pxfwritable_import');
{code}
Actual behavior:
{code}
select * from pxf_jdbc_multiple_fragments_by_date;
ERROR: remote component error (500) from '127.0.0.1:51200': type Exception
report message description The server encountered an internal error
that prevented it from fulfilling this request. exception
java.lang.NullPointerException (libchurl.c:897)
{code}
Expected behavior: meaningful and user-friendly message.
# User didn't pass interval:
{code}
CREATE EXTERNAL TABLE pxf_jdbc_multiple_fragments_by_date (t1 text, t2
text, num1 int, dub1 double precision, dec1 numeric, tm timestamp, r real,
bg bigint, b boolean, tn smallint, sml smallint, dt date, vc1 varchar(5), c1
char(3), bin bytea) LOCATION
(E'pxf://127.0.0.1:51200/hawq_types?PROFILE=Jdbc&JDBC_DRIVER=org.postgresql.Driver&DB_URL=jdbc:postgresql:pxfautomation//localhost:5432&PARTITION_BY=dt:date&RANGE=2015-03-06:2015-03-20&USER=adiachenko')
FORMAT 'CUSTOM' (formatter='pxfwritable_import');
{code}
Actual behavior:
{code}
ERROR: remote component error (500) from '127.0.0.1:51200': type Exception
report message description The server encountered an internal error
that prevented it from fulfilling this request. exception
java.lang.NullPointerException (libchurl.c:897)
{code}
> Improve partition parameters validation for PXF-JDBC plugin
> -----------------------------------------------------------
>
> Key: HAWQ-1461
> URL: https://issues.apache.org/jira/browse/HAWQ-1461
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: PXF
> Reporter: Oleksandr Diachenko
> Assignee: Ed Espino
>
> h3. User didn't pass interval type, query fails with NPE:
> {code}
> CREATE EXTERNAL TABLE pxf_jdbc_multiple_fragments_by_date (t1 text, t2
> text, num1 int, dub1 double precision, dec1 numeric, tm timestamp, r real,
> bg bigint, b boolean, tn smallint, sml smallint, dt date, vc1 varchar(5), c1
> char(3), bin bytea) LOCATION
> (E'pxf://127.0.0.1:51200/hawq_types?PROFILE=Jdbc&JDBC_DRIVER=org.postgresql.Driver&DB_URL=jdbc:postgresql:pxfautomation//localhost:5432&PARTITION_BY=dt:date&RANGE=2015-03-06:2015-03-20&INTERVAL=1&USER=adiachenko')
> FORMAT 'CUSTOM' (formatter='pxfwritable_import');
> {code}
> Actual behavior:
> {code}
> select * from pxf_jdbc_multiple_fragments_by_date;
> ERROR: remote component error (500) from '127.0.0.1:51200': type Exception
> report message description The server encountered an internal error
> that prevented it from fulfilling this request. exception
> java.lang.NullPointerException (libchurl.c:897)
> {code}
> Expected behavior: meaningful and user-friendly message.
> h3. User didn't pass interval:
> {code}
> CREATE EXTERNAL TABLE pxf_jdbc_multiple_fragments_by_date (t1 text, t2
> text, num1 int, dub1 double precision, dec1 numeric, tm timestamp, r real,
> bg bigint, b boolean, tn smallint, sml smallint, dt date, vc1 varchar(5), c1
> char(3), bin bytea) LOCATION
> (E'pxf://127.0.0.1:51200/hawq_types?PROFILE=Jdbc&JDBC_DRIVER=org.postgresql.Driver&DB_URL=jdbc:postgresql:pxfautomation//localhost:5432&PARTITION_BY=dt:date&RANGE=2015-03-06:2015-03-20&USER=adiachenko')
> FORMAT 'CUSTOM' (formatter='pxfwritable_import');
> {code}
> Actual behavior:
> {code}
> ERROR: remote component error (500) from '127.0.0.1:51200': type Exception
> report message description The server encountered an internal error
> that prevented it from fulfilling this request. exception
> java.lang.NullPointerException (libchurl.c:897)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
