Top "Hiveql" questions

I'm writing a code in HIVE to create a table consisting of 1300 rows and 6 columns: create table test1 as SELECT …

I have created a table in hive, I would like to know which directory my table is created in? I …

I'm a novice. I have a employee table with a column specifying the joining date and I want to retrieve …

I'm a noobie here. I'm trying to retrieve top 2 tables from my employee list based on salary in hive (version 0.11). …

This is the below Hive Table CREATE EXTERNAL TABLE IF NOT EXISTS SampleTable ( USER_ID BIGINT, NEW_ITEM ARRAY<…

How can I generate row numbers for an existing table while running a select query? For example: select row_number(), * …

I am not sure what I am doing wrong here: hive> CREATE TABLE default.testtbl(int1 INT,string1 STRING) …

Based on the Hive doc below: Rename Table ALTER TABLE table_name RENAME TO new_table_name; This statement lets …

I have configured my Hive as given on link: http://www.youtube.com/watch?v=Dqo1ahdBK_A, but I …

I have the following string representation of a timestamp in my Hive table: 20130502081559999 I need to convert it to a …