05-28-2016 07:06 PM
In Hive query editor, it shows "The operation has no results.".
In Impala, it shows:
Your query has the following error(s):
AnalysisException: Failed to load metadata for table: 'intermediate_access_logs' CAUSED BY: TableLoadingException: Failed to load metadata for table: intermediate_access_logs CAUSED BY: InvalidStorageDescriptorException: Impala does not support tables of this type. REASON: SerDe library 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' is not supported.
05-29-2016 04:12 AM
I double checked and confirmed the log exists in hdfs:
[cloudera@quickstart examples]$ hadoop fs -ls /user/hive/warehouse/original_access_logs
Found 1 items
-rw-r--r-- 1 hdfs supergroup 39593868 2016-05-28 06:23 /user/hive/warehouse/original_access_logs/access.log.2
05-29-2016 04:01 PM
I repeated the process and it works now, but the last script is showing no result, I will open a different post for that.
06-01-2016 09:56 AM