[
https://issues.apache.org/jira/browse/HAWQ-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Diachenko updated HAWQ-1084:
--------------------------------------
Description:
{code}
PXF Hive Table "default.hive_abc"
Column | Type
--------+--------
t0 | text
num1 | int4
d1 | float8
t1 | text
PXF Hive Table "default.hive_abc222"
Column | Type
--------+--------
d1 | float8
t0 | text
num1 | int4
t1 | text
PXF Hive Table "default.hive_avro_table"
Column | Type
--------+--------
t0 | text
d1 | float8
num1 | int4
t1 | text
PXF Hive Table "default.hive_binary"
Column | Type
--------+-------
b1 | bytea
PXF Hive Table "default.hive_collections_table"
Column | Type
--------+--------
ut1 | text
sr1 | text
m1 | text
a1 | text
s1 | text
f1 | float4
PXF Hive Table "default.hive_many_partitioned_table"
Column | Type
--------+-----------
s1 | text
s2 | text
n1 | int4
d1 | float8
dc1 | numeric
tm | timestamp
f | float4
bg | int8
b | bool
tn | int2
sml | int2
dt | date
vc1 | varchar
c1 | bpchar
bin | bytea
PXF Hive Table "default.hive_orc_all_types"
Column | Type
--------+-----------
bin | bytea
c1 | bpchar
vc1 | varchar
dt | date
sml | int2
tn | int2
b | bool
bg | int8
f | float4
tm | timestamp
dc1 | numeric
d1 | float8
n1 | int4
s2 | text
s1 | text
PXF Hive Table "default.hive_orc_snappy"
Column | Type
--------+--------
t0 | text
t1 | text
num1 | int4
d1 | float8
PXF Hive Table "default.hive_orc_table"
Column | Type
--------+--------
d1 | float8
num1 | int4
t1 | text
t0 | text
PXF Hive Table "default.hive_orc_zlib"
Column | Type
--------+--------
t0 | text
t1 | text
num1 | int4
d1 | float8
PXF Hive Table "default.hive_parquet_table"
Column | Type
--------+--------
d1 | float8
num1 | int4
t1 | text
t0 | text
PXF Hive Table "default.hive_partitioned_clustered_sorted_table"
Column | Type
--------+--------
fmt | text
d1 | float8
num1 | int4
t1 | text
t0 | text
PXF Hive Table "default.hive_partitioned_clustered_table"
Column | Type
--------+--------
fmt | text
d1 | float8
num1 | int4
t1 | text
t0 | text
PXF Hive Table "default.hive_partitioned_skewed_stored_table"
Column | Type
--------+--------
fmt | text
d1 | float8
num1 | int4
t1 | text
t0 | text
PXF Hive Table "default.hive_partitioned_skewed_table"
Column | Type
--------+--------
fmt | text
t0 | text
d1 | float8
num1 | int4
t1 | text
PXF Hive Table "default.hive_partitioned_table"
Column | Type
--------+--------
t0 | text
t1 | text
num1 | int4
d1 | float8
fmt | text
PXF Hive Table "default.hive_rc_table"
Column | Type
--------+--------
t0 | text
d1 | float8
num1 | int4
t1 | text
PXF Hive Table "default.hive_rc_table_no_serde"
Column | Type
--------+--------
d1 | float8
num1 | int4
t1 | text
t0 | text
PXF Hive Table "default.hive_sequence_table"
Column | Type
--------+--------
t0 | text
t1 | text
num1 | int4
d1 | float8
PXF Hive Table "default.hive_small_data"
Column | Type
--------+--------
d1 | float8
n1 | int4
s2 | text
s1 | text
PXF Hive Table "default.hive_small_data_no_data_file"
Column | Type
--------+--------
d1 | float8
n1 | int4
s2 | text
s1 | text
PXF Hive Table "default.hive_table"
Column | Type
--------+--------
s1 | text
n1 | int4
d1 | float8
bg | int8
b | bool
PXF Hive Table "default.hive_types"
Column | Type
--------+-----------
bin | bytea
c1 | bpchar
vc1 | varchar
dt | date
sml | int2
tn | int2
b | bool
bg | int8
f | float4
tm | timestamp
dc1 | numeric
d1 | float8
n1 | int4
s2 | text
s1 | text
PXF Hive Table "default.hivebinaryrc"
Column | Type
--------+-------
data2 | bytea
data1 | bytea
n1 | int4
s1 | text
PXF Hive Table "default.many_partitions"
Column | Type
--------+------
date_i | text
i | int4
PXF Hive Table "default.rc_hive_types"
Column | Type
--------+-----------
bg | int8
b | bool
si | int2
bin | bytea
f | float4
tm | timestamp
d1 | float8
n1 | int4
s1 | text
key | text
PXF Hive Table "default.reg_collections"
Column | Type
--------+--------
sr1 | text
m1 | text
a1 | text
f1 | float4
s1 | text
PXF Hive Table "default.reg_heterogen"
Column | Type
--------+--------
fmt | text
d1 | float8
num1 | int4
t1 | text
t0 | text
{code}
> Sometimes psql crashes with "out of memory" on \d hcatalog.* command
> --------------------------------------------------------------------
>
> Key: HAWQ-1084
> URL: https://issues.apache.org/jira/browse/HAWQ-1084
> Project: Apache HAWQ
> Issue Type: Bug
> Components: PXF
> Reporter: Oleksandr Diachenko
> Assignee: Lei Chang
>
> {code}
> PXF Hive Table "default.hive_abc"
> Column | Type
> --------+--------
> t0 | text
> num1 | int4
> d1 | float8
> t1 | text
> PXF Hive Table "default.hive_abc222"
> Column | Type
> --------+--------
> d1 | float8
> t0 | text
> num1 | int4
> t1 | text
> PXF Hive Table "default.hive_avro_table"
> Column | Type
> --------+--------
> t0 | text
> d1 | float8
> num1 | int4
> t1 | text
> PXF Hive Table "default.hive_binary"
> Column | Type
> --------+-------
> b1 | bytea
> PXF Hive Table "default.hive_collections_table"
> Column | Type
> --------+--------
> ut1 | text
> sr1 | text
> m1 | text
> a1 | text
> s1 | text
> f1 | float4
> PXF Hive Table "default.hive_many_partitioned_table"
> Column | Type
> --------+-----------
> s1 | text
> s2 | text
> n1 | int4
> d1 | float8
> dc1 | numeric
> tm | timestamp
> f | float4
> bg | int8
> b | bool
> tn | int2
> sml | int2
> dt | date
> vc1 | varchar
> c1 | bpchar
> bin | bytea
> PXF Hive Table "default.hive_orc_all_types"
> Column | Type
> --------+-----------
> bin | bytea
> c1 | bpchar
> vc1 | varchar
> dt | date
> sml | int2
> tn | int2
> b | bool
> bg | int8
> f | float4
> tm | timestamp
> dc1 | numeric
> d1 | float8
> n1 | int4
> s2 | text
> s1 | text
> PXF Hive Table "default.hive_orc_snappy"
> Column | Type
> --------+--------
> t0 | text
> t1 | text
> num1 | int4
> d1 | float8
> PXF Hive Table "default.hive_orc_table"
> Column | Type
> --------+--------
> d1 | float8
> num1 | int4
> t1 | text
> t0 | text
> PXF Hive Table "default.hive_orc_zlib"
> Column | Type
> --------+--------
> t0 | text
> t1 | text
> num1 | int4
> d1 | float8
> PXF Hive Table "default.hive_parquet_table"
> Column | Type
> --------+--------
> d1 | float8
> num1 | int4
> t1 | text
> t0 | text
> PXF Hive Table "default.hive_partitioned_clustered_sorted_table"
> Column | Type
> --------+--------
> fmt | text
> d1 | float8
> num1 | int4
> t1 | text
> t0 | text
> PXF Hive Table "default.hive_partitioned_clustered_table"
> Column | Type
> --------+--------
> fmt | text
> d1 | float8
> num1 | int4
> t1 | text
> t0 | text
> PXF Hive Table "default.hive_partitioned_skewed_stored_table"
> Column | Type
> --------+--------
> fmt | text
> d1 | float8
> num1 | int4
> t1 | text
> t0 | text
> PXF Hive Table "default.hive_partitioned_skewed_table"
> Column | Type
> --------+--------
> fmt | text
> t0 | text
> d1 | float8
> num1 | int4
> t1 | text
> PXF Hive Table "default.hive_partitioned_table"
> Column | Type
> --------+--------
> t0 | text
> t1 | text
> num1 | int4
> d1 | float8
> fmt | text
> PXF Hive Table "default.hive_rc_table"
> Column | Type
> --------+--------
> t0 | text
> d1 | float8
> num1 | int4
> t1 | text
> PXF Hive Table "default.hive_rc_table_no_serde"
> Column | Type
> --------+--------
> d1 | float8
> num1 | int4
> t1 | text
> t0 | text
> PXF Hive Table "default.hive_sequence_table"
> Column | Type
> --------+--------
> t0 | text
> t1 | text
> num1 | int4
> d1 | float8
> PXF Hive Table "default.hive_small_data"
> Column | Type
> --------+--------
> d1 | float8
> n1 | int4
> s2 | text
> s1 | text
> PXF Hive Table "default.hive_small_data_no_data_file"
> Column | Type
> --------+--------
> d1 | float8
> n1 | int4
> s2 | text
> s1 | text
> PXF Hive Table "default.hive_table"
> Column | Type
> --------+--------
> s1 | text
> n1 | int4
> d1 | float8
> bg | int8
> b | bool
> PXF Hive Table "default.hive_types"
> Column | Type
> --------+-----------
> bin | bytea
> c1 | bpchar
> vc1 | varchar
> dt | date
> sml | int2
> tn | int2
> b | bool
> bg | int8
> f | float4
> tm | timestamp
> dc1 | numeric
> d1 | float8
> n1 | int4
> s2 | text
> s1 | text
> PXF Hive Table "default.hivebinaryrc"
> Column | Type
> --------+-------
> data2 | bytea
> data1 | bytea
> n1 | int4
> s1 | text
> PXF Hive Table "default.many_partitions"
> Column | Type
> --------+------
> date_i | text
> i | int4
> PXF Hive Table "default.rc_hive_types"
> Column | Type
> --------+-----------
> bg | int8
> b | bool
> si | int2
> bin | bytea
> f | float4
> tm | timestamp
> d1 | float8
> n1 | int4
> s1 | text
> key | text
> PXF Hive Table "default.reg_collections"
> Column | Type
> --------+--------
> sr1 | text
> m1 | text
> a1 | text
> f1 | float4
> s1 | text
> PXF Hive Table "default.reg_heterogen"
> Column | Type
> --------+--------
> fmt | text
> d1 | float8
> num1 | int4
> t1 | text
> t0 | text
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
