Yes i did that but i am struck to get the created date and location, so that i can able to use 90 days logic. Can you advise how this can be done using scripting
Location: Asia Pacific, Cyberspace, in the Dark Dystopia
Posts: 19,118
Thanks Given: 2,351
Thanked 3,359 Times in 1,878 Posts
Why did you not post the command and the output?
We cannot help you if you plan to operate here in secret and not posting your code and the output fully.
Sorry to tell you. We cannot help you if you are not going to post key the input/output information required since most the users here are not using Hive.
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)
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 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)
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)
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)