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
apport-cli(1)						      General Commands Manual						     apport-cli(1)

NAME
apport-cli - Command line client for reporting problems SYNOPSIS
apport-cli apport-cli -c report apport-cli -f -p package apport-cli -f -P pid DESCRIPTION
apport automatically collects data from crashed processes and compiles a problem report in /var/crash/. This is a command line frontend for reporting those crashes to the developers. It can also be used to report bugs about packages or running processes. For desktop systems with a graphical user interface, you should consider installing the GTK or Qt user interface (apport-gtk or apport-qt). apport-cli is mainly intended to be used on servers. When called without any options, it processes the pending crash reports and offers to report them one by one. You can also display the entire report to see what is sent to the software developers. OPTIONS
-c report, --crash-file=report Instead of walking over the new crash reports in /var/crash/, report a particular report in an arbitrary file location. This is useful for copying a crash report to a machine with internet connection and reporting it from there. -f, --file-bug Report a (non-crash) problem. Requires specifying --package or --pid. This will automatically attach information about your operat- ing sytem and the package version etc. to the bug report, so that the developers have some important context. -p package, --package=package When being used in --file-bug mode, specify the package to report the problem against. -P pid, --pid=pid When being used in --file-bug mode, specify the PID (process ID) of a running program to report the problem against. This can be determined with e. g. ps -ux. ENVIRONMENT
APPORT_IGNORE_OBSOLETE_PACKAGES Apport refuses to create bug reports if the package or any dependency is not current. If this environment variable is set, this check is waived. Experts who will thoroughly check the situation before filing a bug report can define this in their ~/.bashrc or temporarily when calling the apport frontend (-cli, -gtk, or -qt). AUTHOR
apport and the accompanying tools are developed by Martin Pitt <martin.pitt@ubuntu.com>. Martin Pitt August 01, 2007 apport-cli(1)
All times are GMT -4. The time now is 12:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy