Sponsored Content
Top Forums Programming How to arhive hive external tables? Post 303035587 by Neo on Wednesday 29th of May 2019 02:29:22 AM
Old 05-29-2019
Just take the hive cli command you want and execute in silent mode similar to this example below but use your own cli commands and logic:

Code:
 $hive -S -e 'select col from tab1' > a.txt

Experiment and learn.
 

5 More Discussions You Might Find Interesting

1. 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

2. 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

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

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

5. 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
NETIO230A-CLI(1)					      General Commands Manual						  NETIO230A-CLI(1)

NAME
netio230a-cli - CLI to python-netio230a SYNOPSIS
netio230a-cli [--host HOST] [--port PORT] [--username USERNAME] [--password PASSWORD] -s SOCKET [--on] DESCRIPTION
netio230a-cli is a command line interface to access the Koukaam NETIO-230A, a cheap but advanced multiple socket with Ethernet control. Options: -? show help message and exit -h HOST, --host=HOST Hostname for the device (defaults to the first one found by the discovery in your LAN) -p PORT, --port=PORT TCP port (defaults to 1234) -u USERNAME, --username=USERNAME username to use for login (defaults to admin) -w PASSWORD, --password=PASSWORD password to use for login (will ask if left empty) -s SOCKET#, --socket=SOCKET# socketnumber (1-4) to switch on/off --on switch on when --on set, off if omitted AUTHOR
netio230a-cli was written by Philipp Klaus <philipp.l.klaus@web.de>. This manual page was written by Philipp Huebner <debalance@debian.org>, for the Debian project (and may be used by others). SEE ALSO
netio230a-discover(1), netio230a-gui(1) netio230a-cli 2010-03-09 NETIO230A-CLI(1)
All times are GMT -4. The time now is 10:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy