How to export hive table data to a file on local UNIX?
Hi All ,
I am stuck on the below situation.I have a table called "test" which are created on hive.I need to export the data from hive to a file(test.txt) on local unix system.I have tried the below command ,but its giving the exception .
Code:
hive -e "select * from test " > /home/user/test.txt ;
Error is like below :
Code:
NoViableAltException(26@[])
at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:
at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:19
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:434)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:352)
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:995)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1038)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:931)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:921)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:2
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:422)
at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:790
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:684)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:623)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
FAILED: ParseException line 1:0 cannot recognize input near 'hive' '-' 'e'
If anyone can help me in this regard ,it will be really beneficial for me.Thanks !
Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Hi All,
I need to write a shell script(ksh) to take the tables backup in oracle(exporting tables data).
The tables list is not static, and those are selecting through dynamic sql
query. Can any body help how to write this shell script.
Thanks, (3 Replies)
Hi,
I have a table (e.g.):
a 1 e 4 5 6
b 2 r 4 4 2
c 5 r 3 7 1
d 9 t 4 4 9
.
.
What I need to do is to set the values of some values in column 2 to negative values. For example, the values 2 and 9 should become -2 and -9 in the modified file. How should I go about... (2 Replies)
Hi
I need help on this. Its very urgent for me.. please try to help me out..
I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export... (2 Replies)
Hi ,
I would like to get some suggestion from the experts.
My requirement is to export oracle table data as an xml file.
Any unix/linux tools, scripts available?
Regards, (2 Replies)
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea . (2 Replies)
Hi all,
Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table.
Please see the attached html and PNG of what it looks like.
... (7 Replies)
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)
HI Team,
I am working on reading hive table and send email in email body using shell script, can you please help on fixing the errors: I have 6 columns in my hive table and trying to send the email in the mail body.
below script:
#!/bin/bash
hive -e 'SELECT count(*) from db.table' >... (4 Replies)
Discussion started by: Mi4304
4 Replies
LEARN ABOUT MOJAVE
serialver
serialver(1) General Commands Manual serialver(1)NAME
serialver - serial version command
SYNOPSIS
serialver [ options ] [ classnames ]
options
Command-line options, as specified in this document.
classnames
One or more class names.
DESCRIPTION
serialver returns the serialVersionUID for one or more classes in a form suitable for copying into an evolving class. When invoked with no
arguments, it prints a usage line.
OPTIONS -classpath <directories and zip/jar files separated by:>
Set search path for application classes and resources.
-show Displays a simple user interface. Enter the full class name and press either the Enter key or the Show button to display
the serialVersionUID.
-Joption Pass option to the Java virtual machine, where option is one of the options described on the man page for the java applica-
tion launcher, java(1). For example, -J-Xms48m sets the startup memory to 48 megabytes. It is a common convention for -J to
pass options to the underlying virtual machine.
SEE ALSO
See (or search java.sun.com) for the following:
java.io.ObjectStreamClass @
http://java.sun.com/j2se/1.5/docs/api/java/io/ObjectStreamClass.html
24 June 2004 serialver(1)