I have one partitioned table 'table1' and I'm able to run select clause on this table in Athena and it gives result as well.
However, when I try to run the query on this Table 'table1' using Lambda Function, it gives me the following Error
'SYNTAX_ERROR: line 1:8: SELECT * not allowed from relation that has no columns'
Below is the python script of Lambda
client = boto3.client('athena')
#Setup and Perform query
response = client.start_query_execution(
QueryString = 'Select * FROM table1',
QueryExecutionContext = {
'Database' : 'test'
},
ResultConfiguration = {
'OutputLocation': 's3://test/'
}
)