Hive Insert and Select only specific columns ( not all columns ) - Partitioned table

2019-05-27 Thread Raviprasad T
*emp ( Hive emp table, Non partitioned table )* empo ename sal deptno *emp_parquet* ( Hive emp_parquet table Partitioned by deptno ) empo ename sal Partition by deptno I am having two tables emp ( text file format ) and emp_parquet ( Parquet file format ) Both are have same colu

Fwd: Hive Insert and Select only specific columns ( not all columns ) - Partitioned table

2019-05-29 Thread Raviprasad T
insert only empno and sal columns ) -- Forwarded message - From: Raviprasad T Date: Mon, May 27, 2019 at 11:00 PM Subject: Hive Insert and Select only specific columns ( not all columns ) - Partitioned table To: *emp ( Hive emp table, Non partitioned table )* empo ename

Which version of Hive support : creating Procedure

2020-01-13 Thread Raviprasad T
Hi, We are using Hive version ( 2.1.1) & CDH version ( 6.2.1). Can you please let me know, Am I able to create Procedure in this version of Hive (2.1.1). I try to create the below procedure in Hive. It is throwing error. hive> create procedure set_message (IN Name string). Error me