[
https://issues.apache.org/jira/browse/HAWQ-518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Goden Yao updated HAWQ-518:
---------------------------
Fix Version/s: 2.0.0.0-incubating
> hawqextract column context does not exist error
> -----------------------------------------------
>
> Key: HAWQ-518
> URL: https://issues.apache.org/jira/browse/HAWQ-518
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Command Line Tools
> Reporter: Daniel Lynch
> Assignee: Lei Chang
> Fix For: 2.0.0.0-incubating
>
>
> When running hawq extract python stack trace is returned because pg_aoseg no
> longer has a column called content
> https://github.com/apache/incubator-hawq/pull/305
> ```
> [gpadmin@node2 ~]$ hawq extract -o rank_table.yaml foo
> 20160129:23:21:41:004538 hawqextract:node2:gpadmin-[INFO]:-try to connect
> database localhost:5432 gpadmin 20160129:23:21:41:004538
> hawqextract:node2:gpadmin-[INFO]:-try to extract metadata of table 'foo'
> 20160129:23:21:41:004538 hawqextract:node2:gpadmin-[INFO]:--- detect
> FileFormat: AO 20160129:23:21:41:004538 hawqextract:node2:gpadmin-[INFO]:---
> extract AO_FileLocations Traceback (most recent call last): File
> "/usr/local/hawq-master/bin/hawqextract", line 551, in <module>
> sys.exit(main()) File "/usr/local/hawq-master/bin/hawqextract", line 528, in
> main metadata = extract_metadata(conn, args[0]) File
> "/usr/local/hawq-master/bin/hawqextract", line 444, in extract_metadata
> cases[file_format]() File "/usr/local/hawq-master/bin/hawqextract", line 363,
> in extract_AO_metadata 'Files': get_ao_table_files(rel_pgclass['oid'],
> rel_pgclass['relfilenode']) File "/usr/local/hawq-master/bin/hawqextract",
> line 322, in get_ao_table_files for f in accessor.get_aoseg_files(oid): File
> "/usr/local/hawq-master/bin/hawqextract", line 164, in get_aoseg_files return
> self.exec_query(qry) File "/usr/local/hawq-master/bin/hawqextract", line 129,
> in exec_query return self.conn.query(sql).dictresult() pg.ProgrammingError:
> ERROR: column "content" does not exist LINE 2: SELECT content, segno as
> fileno, eof as filesize
> ```
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
