While running an report on the Warehouse, the following error is displayed:
DataSourceSAW.Query Execute failed,Execution Error:return code 1 from org.apache.hadoop.hive.ql.exec.DLLTask. org.apache.hadoop.hive.ql.metadata.HiveException: at least one column must be specified for the table
This error occurs when the report is run from the /logs directory rather than the /sessions directory. The /logs directory in the warehouse stores the raw logs and the /sessions stores the actual meta.
Unless raw_log is used in the Select field to query for the raw logs, select the /sessions option for the From value on the Build Rule page as shown below.