You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am attempting to create a view in AWS Athena using $file_modifed_time. However, I continue to get an error that reads,
"This query ran against the "" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id:"
I can run the following query without any problems:
select "$file_modified_time" as last_update_date from MY_TABLE
I can also run the following create view without any problem (using $path):
create or replace view MY_VIEW as
select "$path" as my_path from MY_TABLE
However, I cannot create a view from $file_modified_time:
create or replace view MY_VIEW as
select "$file_modified_time" as last_update_date from MY_TABLE
without getting the error listed above. Is this a bug?
The text was updated successfully, but these errors were encountered:
@mlamias I tried creating a similar view using the hive connector and I don't see any issue on my end. Based on the error message, wanted to confirm if you are using Amazon Athena? If yes, please reach out to them since it's a closed-source product. If you are on open-source Presto, can you please let us know the Presto version being used and if possible please add the full stacktrace from Presto UI?
I am attempting to create a view in AWS Athena using
$file_modifed_time
. However, I continue to get an error that reads,"This query ran against the "" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id:"
I can run the following query without any problems:
I can also run the following create view without any problem (using
$path
):However, I cannot create a view from $file_modified_time:
without getting the error listed above. Is this a bug?
The text was updated successfully, but these errors were encountered: