In this blog post, I will show how to transform the following data in Hive and turn it into a table with the following output: 1. To prepare the table, firstly need to create a dummy table with one record: This is to allow us to insert array data into …
From time to time, we need to do troubleshooting steps for locating the root cause of Kerberos failure in Hive. I will outline below steps in order to turn on debugging message from both Client and HiveServer2 server side. To enable on Hive Client side (beeline), simply add the following …
Yesterday, I was dealing with an issue that when running a very simple Impala SELECT query, it failed with “Incompatible Parquet schema” error. I have confirmed the following workflow that triggered the error: Parquet file is created from external library Load the parquet file into Hive/Impala table Query the table …
My new Snowflake Blog is now live. I will not be updating this blog anymore but will continue with new contents in the Snowflake world!