{"version":"1.0","type":"rich","title":"Apache log analysis with Hadoop, Hive and HBase","description":"This example demonstrates how to analyze Apache web server logs using Hadoop, Hive, and HBase. It shows the process of transforming raw gzipped log files stored on the Hadoop Distributed File System into a structured HBase table, then querying that table to find the 50 most popular pages and categorize article hits by publication year. The Hive script uses the RegexSerDe to parse log lines, the HBaseStorageHandler to map Hive columns to HBase column families (m, r, a), and SQL-like queries with functions such as `unix_timestamp`, `re_extract`, and `TABLESAMPLE` to clean and aggregate the data.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-e7630f58d4a1dfad43c07474bfdac87d?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}