05-29-2019
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
5 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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 PHP
dateinterval
DATEINTERVAL(3) 1 DATEINTERVAL(3)
The DateInterval class
INTRODUCTION
Represents a date interval.
A date interval stores either a fixed amount of time (in years, months, days, hours etc) or a relative time string in the format that
DateTime's constructor supports.
CLASS SYNOPSIS
DateInterval
DateInterval
Properties
o public integer$y
o public integer$m
o public integer$d
o public integer$h
o public integer$i
o public integer$s
o public integer$invert
o public mixed$days
Methods
o public DateInterval::__construct (string $interval_spec)
o publicstatic DateInterval DateInterval::createFromDateString (string $time)
o public string DateInterval::format (string $format)
PROPERTIES
o $y
- Number of years.
o $m
- Number of months.
o $d
- Number of days.
o $h
- Number of hours.
o $i
- Number of minutes.
o $s
- Number of seconds.
o $invert
- Is 1 if the interval represents a negative time period and 0 otherwise. See DateInterval::format.
o $days
- If the DateInterval object was created by DateTime.diff(3), then this is the total number of days between the start and end
dates. Otherwise, $days will be FALSE. Before PHP 5.4.20/5.5.4 instead of FALSE you will receive -99999 upon accessing the prop-
erty.
PHP Documentation Group DATEINTERVAL(3)