Daniel Lynch created HAWQ-535:
---------------------------------

             Summary: hawqextract column context does not exist error
                 Key: HAWQ-535
                 URL: https://issues.apache.org/jira/browse/HAWQ-535
             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

```
[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)

Reply via email to