We're updating the issue view to help you get more done. 
Learn more or See the old view

Not recognizable column in query result

Description

This change in PLFM added a new field in the SelectColumn object: https://github.com/Sage-Bionetworks/Synapse-Repository-Services/pull/3348/files#diff-3391b309663d046c639a8b5ad69aa0d1
The Python client code does not recognize the new field. This cause error running table query against staging in both R and Python client. My test against staging:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 >>> import synapseclient >>> syn = synapseclient.login() Welcome, Kimyen Truong! >>> syn.repoEndpoint 'https://repo-staging.prod.sagebase.org/repo/v1' >>> qr = syn.tableQuery("select * from syn11213698 limit 1") [####################]100.00% 1/1 Done... Downloading [####################]100.00% 50.0bytes/50.0bytes (19.1kB/s) Job-67571347474773473790060892.csv Done... Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/Users/kimyentruong/Documents/synapsePythonClient/synapseclient/client.py", line 2876, in tableQuery return CsvFileTable.from_table_query(self, query, **kwargs) File "/Users/kimyentruong/Documents/synapsePythonClient/synapseclient/table.py", line 1558, in from_table_query headers=[SelectColumn(**header) for header in download_from_table_result['headers']]) File "/Users/kimyentruong/Documents/synapsePythonClient/synapseclient/table.py", line 1558, in <listcomp> headers=[SelectColumn(**header) for header in download_from_table_result['headers']]) TypeError: __init__() got an unexpected keyword argument 'columnSQL' >>>

If we release staging without a fix, all table queries in the Python client and synapser client will be broken.

Environment

None

Status

Assignee

Kimyen Truong

Reporter

Kimyen Truong

Labels

None

Validator

Ziming Dong

Release Version History

None

Fix versions

Priority

Critical