Unable to query COLUMNS data after reprovisioning default engine

The query to get columns data from information schema tables
select * from INFORMATION_SCHEMA.COLUMNS results in the error nullPointerException with the following message

{"errorMessage":"Unexpected error occurred","context":["SqlOperatorImpl INFO_SCHEMA_SUB_SCAN","Location 0:0:6","Fragment 0:0"],"moreInfo":""}

Previously, this query ran only on the default engine and threw the same error even before when it was run on other engines

It has to do with file system authentication. How is “dremio” user authenticating to where you have local and dist pointed to? In linux the default user is “dremio”, so it needs to have permissions to the db, fs, catalog, etc. folders that dremio uses.

Our deployment is the standard AWS Marketplace community one, I am assuming all that would be taken care of? no?


Can you please share the job profile

81c8f7db-2de2-4518-a8a8-090b09f0ba01.zip (11.4 KB)

@balaji.ramaswamy here’s a copy of the query profile