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
wxKeyEvent(3erl)					     Erlang Module Definition						  wxKeyEvent(3erl)

NAME
wxKeyEvent - See external documentation: wxKeyEvent. DESCRIPTION
See external documentation: wxKeyEvent . Use wxEvtHandler:connect/3 with EventType: : char , char_hook , key_down , key_up See also the message variant #wxKey{ } event record type. This class is derived (and can use functions) from: wxEvent DATA TYPES
wxKeyEvent() : An object reference, The representation is internal and can be changed without notice. It can't be used for comparsion stored on disc or distributed for use on other nodes. EXPORTS
altDown(This::wxKeyEvent()) -> bool() See external documentation . cmdDown(This::wxKeyEvent()) -> bool() See external documentation . controlDown(This::wxKeyEvent()) -> bool() See external documentation . getKeyCode(This::wxKeyEvent()) -> integer() See external documentation . getModifiers(This::wxKeyEvent()) -> integer() See external documentation . getPosition(This::wxKeyEvent()) -> {X::integer(), Y::integer()} See external documentation . getRawKeyCode(This::wxKeyEvent()) -> integer() See external documentation . getRawKeyFlags(This::wxKeyEvent()) -> integer() See external documentation . getUnicodeKey(This::wxKeyEvent()) -> integer() See external documentation . getX(This::wxKeyEvent()) -> integer() See external documentation . getY(This::wxKeyEvent()) -> integer() See external documentation . hasModifiers(This::wxKeyEvent()) -> bool() See external documentation . metaDown(This::wxKeyEvent()) -> bool() See external documentation . shiftDown(This::wxKeyEvent()) -> bool() See external documentation . AUTHORS
<> wxErlang 0.98.9 wxKeyEvent(3erl)
All times are GMT -4. The time now is 03:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy