You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Oleksandr Diachenko (JIRA)" <ji...@apache.org> on 2016/10/04 21:07:20 UTC

[jira] [Updated] (HAWQ-1084) Sometimes psql crashes with "out of memory" on \d hcatalog.* command

     [ https://issues.apache.org/jira/browse/HAWQ-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Oleksandr Diachenko updated HAWQ-1084:
--------------------------------------
    Assignee: Vineet Goel  (was: Lei Chang)

> 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: Vineet Goel
>
> {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)