This gist includes hive ql scripts to create an external partitioned table for Syslog generated log files using regex serde; Usecase: Count the number of occurances of processes that got logged, by year, month, day and process. Includes: --------- Sample data and structure: 01-SampleDataAndStructure Data download: 02-DataDownload Data load commands: 03-DataLoadCommands Hive commands: 04-HiveCommands Sample output: 05-SampleOutput