Hive creates folders like HIVE_UNION_SUBDIR_1
When using Tez, Inserting data using SELECT / UNION ALL will create non standard folders such as HIVE_UNION_SUBDIR_1.. n under
Read more
Hive
Multiplying two positive numbers resulting in a negative number
Weird multiplication Error What would you do when multiplying two positive numbers resulting in a negative result ? If its
Read more
Best way to Export Hive table to CSV file
This post is to explain different options available to export Hive Table (ORC, Parquet or Text) to CSV File. Expected
Read moreHive Sqoop change scratchdir
In this post Hive Job Submission failed with exception I had mentioned about deleting .Trash folder. For any reason if you
Read more
Hive Job Submission failed with exception
Job Submission failed with exception ‘org.apache.hadoop.hdfs.protocol.DSQuotaExceededException(The DiskSpace quota of /user/username is exceeded: quota = xx’ This is a common problem
Read moreHive : Create database in different folder
When database is created in Hive, its usually saved in default folder /user/hive/warehouse/yourdabase.db If alternate location is needed, then create database
Read moreHive Error : SemanticException TOK_ALLCOLREF
Hive Error : SemanticException TOK_ALLCOLREF is not supported in current context Reason : Select Distinct * From <tablename> Solution :
Read more