How to arhive hive external tables?


 
Thread Tools Search this Thread
Top Forums Programming How to arhive hive external tables?
# 1  
Old 05-29-2019
How to arhive hive external tables?

Hi Guys,

Is there a way to check hive external tables which are created 90 days before and drop those tables along with underlying hdfs data. Can this be achieved in unix script?
# 2  
Old 05-29-2019
You might consider looking at the Hive LanguageManual

Code:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual

There you will see, for example, the Beeline - Command Line Shell.

Code:
https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-Beeline%E2%80%93CommandLineShell

You should be able to use this type of Hive CLI in shell scripts to work with Hive, as needed.
# 3  
Old 05-29-2019
Or, you might consider other Hive CLIs, like

HCatalog CLI


Read the Hives CLI docs and experiment until you find a CLI that suits your needs.
# 4  
Old 05-29-2019
I am using Hive CLI but how can i able to check 90 days created

Code:
desc formatted my_table;

# 5  
Old 05-29-2019
You basically have to write a Hive SQL query to get the information you are seeking.

That's part of the Hive documentation.
# 6  
Old 05-29-2019
How you can get using sql, I need to check the hive tables which are created 90 days before and drop those tables
# 7  
Old 05-29-2019
Execute the CLI command

Code:
desc formatted <database>.<table_name>

on the hive cli.

It will show detailed table information with the creation time.
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract hive table structure

Hi, I need to extract only the create table structure with columns alone. for eg hive_table show create table hive_table: create table hive_table(id number,age number) OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' LOCATION 'hdfs:/path/' I need only below ... (5 Replies)
Discussion started by: rohit_shinez
5 Replies

2. Shell Programming and Scripting

Read CSV file and delete hdfs, hive and hbase tables

I have a CSV file with hdfs directories, hive tables and hbase tables. 1. first column - hdfs directories 2. second column - hive tables 3. third column - hbase tables I have to check the csv file and look for the first column and delete the hdfs directory from the hdfs path, now... (2 Replies)
Discussion started by: shivamayam
2 Replies

3. UNIX for Dummies Questions & Answers

ODBC Hive error

Hi , I am trying to setup HIVE ODBC with below setting Host: Local host port : 10000 Database : Default Hive server type : Hive server 2 Mechanism: User But getting below error: Driver Version: V2.5.0.1001 Running connectivity tests... Attempting connection Failed to... (1 Reply)
Discussion started by: rakesh_411
1 Replies

4. Shell Programming and Scripting

Trouble with external tables

Hi All, My flat file lets say has the following contents AT & T CITIZENS MOHAVE CELLULAR COMMNET DRR E1CELLULAR .... Now, Im trying to select data from a flat file(sitting on unix server) and want to run a simple query as below(running Oracle 10g) SELECT MO_IDENTIFER,... (5 Replies)
Discussion started by: PG3
5 Replies

5. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies
Login or Register to Ask a Question