Using Ambari Core Services
Also available as:
PDF
loading table of contents...

Example Hadoop logs

A working example of creating an external table of Hadoop logs.

CREATE EXTERNAL TABLE hadoop_logs
(
logtime string,
level string,
thread_name string,
logger_name string,
file string,
line_number int,
method string,
log_message string,
cluster string,
type string,
path string,
logfile_line_number int,
host string,
ip string,
id string,
event_md5 string,
message_md5 string,
seq_num int
)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
LOCATION '[SOME_DIRECTORY_PATH]';