Hive is a database built on top of Hadoop and facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible distributed file system.
I am looking for a in-built String split function in Hive? e.g. if String is: A|B|C|D|…
hadoop hivePlease tell me how to delete table from hive and also tell from where i can get more information about …
hadoop hiveIs it possible to do a create table <mytable> as select <query statement> using row format …
hive sql-like create-tableSince there is no IFNULL, ISNULL, or NVL function supported on Hive, I'm having trouble converting NULL to 0. I tried …
sql hiveI have Hadoop 2.7.1 and apache-hive-1.2.1 versions installed on ubuntu 14.0. Why this error is occurring ? Is any metastore installation required? When …
apache hadoop hiveWhat is the difference between an INNER JOIN and LEFT SEMI JOIN? In the scenario below, why am I getting …
sql hql hiveI am using Cloudera's version of Hive and trying to create an external table over a csv file that contains …
hive clouderaI know that you can get column names from a table via the following trick in hive: hive> set …
sql hadoop hiveI'm a novice. I have a employee table with a column specifying the joining date and I want to retrieve …
hadoop hive hiveqlI'm a noobie here. I'm trying to retrieve top 2 tables from my employee list based on salary in hive (version 0.11). …
hadoop hive hiveql