Hive does not support for ISO-8601 timestamp format, like this “2017-02-16T11:24:29.000Z” by default. Check the following test case: 1. Create a file with the following content: 2. Put the file in HDFS: 3. Create an external table links to it: 4. When you select the table, first record will be …
This article explains the steps required to enable audit log for HiveServer2, so that all queries run through HiveServer2 will be audited into a central log file. Please follow the steps below: Go to Cloudera Manager home page > Hive > Configuration Tick “Enable Audit Collection” Ensure “Audit Log Directory” …
Last week, while I was working on Sqoop with Teradata, I noticed one bug that the microseconds part of a Timestamp field got truncated after importing into HDFS. The following is the steps to re-produce the issue: 1. Create a table in Teradata: 2. And sqoop import command: 3. data …
If you get the following error when trying to start up beeline from command line: Based on the stacktrace, we can see that Beeline was at startup phase and was trying to initialize through getConsoleReader method, which will read data from beeline’s history file: By default, the history file is …
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!