[ https://issues.apache.org/jira/browse/HAWQ-519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Radar Lei updated HAWQ-519: --------------------------- Assignee: Lei Chang (was: Radar Lei) > hawqextract column context does not exist error > ----------------------------------------------- > > Key: HAWQ-519 > URL: https://issues.apache.org/jira/browse/HAWQ-519 > Project: Apache HAWQ > Issue Type: Bug > Components: Command Line Tools > Reporter: Daniel Lynch > Assignee: Lei Chang > > 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)