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)
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)
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)
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)
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
LEARN ABOUT DEBIAN
sqlobject-admin
SQLOBJECT-ADMIN(1) General Commands Manual SQLOBJECT-ADMIN(1)NAME
sqlobject-admin - manage your database as defined with SQLObject classes
SYNOPSIS
sqlobject-admin [options] command
DESCRIPTION
The sqlobject-admin tool included with SQLObject allows you to manage your database as defined with SQLObject classes.
Some of the features include creating tables, checking the status of the database, recording a version of a schema, and updating the
database to match the version of the schema in your code.
COMMANDS
The following commands are recognized:
help
Show the help text.
create
Find the tables and create them. Existing tables are simply skipped.
sql
Show the SQL to create all the tables.
drop
Drop tables. Missing tables are skipped.
execute
Execute an arbitrary SQL expression.
list
List out all the found classes.
status
Show if tables are present in the database.
record
Record historical information about the database status
upgrade
Update the database to a new version (as created by record)
OPTIONS -c CONNECTION, --connection=CONNECTION
Connection string for the database .
-f FILENAME, --config-file=FILENAME
Configuration file from which to get the connection to the database.
-m MODULE, --module=MODULE
A module to look in for classes.
-p PACKAGE, --package=PACKAGE
A package to look in.
--class=CLASSMATCH
Restricting the found classes to the matching classes.
--egg=EGG_SPEC
Egg description that should be loaded.
AUTHORS
This manual page was written by Carl Chenet <chaica@ohmytux.com>.
LICENSE
This package is licensed under the GNU Lesser General Public License. You can
find the full text of the LGPL in /usr/share/common-licenses/LGPL in your
Debian system.
06/03/2010 SQLOBJECT-ADMIN(1)