*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
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
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