@lebinh ,
I just installed aq. I encountered several issues
-
I have to downgrade prompt-toolkit to 1.x just to be able to install it locally for debugging
-
I encountered an error while running a simple query:
Then this one showed up:
select count(*) from ec2_instances
Traceback (most recent call last):
File "/usr/local/lib/python3.7/site-packages/aq/__init__.py", line 69, in main
res = execute_query(engine, formatter, parser, query)
File "/usr/local/lib/python3.7/site-packages/aq/__init__.py", line 82, in execute_query
columns, rows = engine.execute(parsed_query, metadata)
File "/usr/local/lib/python3.7/site-packages/aq/engines.py", line 49, in execute
self.load_tables(query, metadata)
File "/usr/local/lib/python3.7/site-packages/aq/engines.py", line 64, in load_tables
self.load_table(table)
File "/usr/local/lib/python3.7/site-packages/aq/engines.py", line 75, in load_table
resource_name, collection_name = table.table.split('_', 1)
AttributeError: 'NoneType' object has no attribute 'split'
When the debugging the following line:
File "/usr/local/lib/python3.7/site-packages/aq/__init__.py", line 82, in execute_query
columns, rows = engine.execute(parsed_query, metadata)
I have these Local Variable:
query: 'SELECT count(*) FROM ec2_instances'
parsed_query: 'SELECT count(*) FROM ec2_instances'
metadata.tables[0]: TableId(database=None, table=None, alias=None)
metadata.tables[0]._fields: ('tables',)
metadata.tables[0][0]._fields: ('database', 'table', 'alias')
metadata.tables[0][0]._fields_defaults: {}
So then when table.table.split('_', 1) is called since table is empty then table.table.split is also null.
Has the parser.parse_query(query) changed and maybe spits out now empty metadata.tables?
Please advise and thanks.
@lebinh ,
I just installed aq. I encountered several issues
I have to downgrade prompt-toolkit to 1.x just to be able to install it locally for debugging
I encountered an error while running a simple query:
Then this one showed up:
When the debugging the following line:
I have these Local Variable:
So then when
table.table.split('_', 1)is called since table is empty then table.table.split is also null.Has the parser.parse_query(query) changed and maybe spits out now empty metadata.tables?
Please advise and thanks.