Re: Extracting data from ELB log date format

2016-09-22 Thread Manish Rangari
:45:22.943762Z',"-MM-dd'T'HH:mm:ss")) > as ts) as t; > > OK > > 2016-09-15 2016 915 23 45 22 > > > > Dudu > > > > *From:* Manish Rangari [mailto:linuxtricksfordev...@gmail.com] > *Sent:* Wednesday, September 21, 2016 4:

RE: Extracting data from ELB log date format

2016-09-21 Thread Markovitz, Dudu
gari [mailto:linuxtricksfordev...@gmail.com] Sent: Wednesday, September 21, 2016 4:23 PM To: user@hive.apache.org Subject: Extracting data from ELB log date format Guys, I am trying to extract date, time, month, minute etc from below timestamp format but did not find any function for this. Can anyone h

Re: Extracting data from ELB log date format

2016-09-21 Thread Haas, Nichole
To: "user@hive.apache.org" Subject: Extracting data from ELB log date format Guys, I am trying to extract date, time, month, minute etc from below timestamp format but did not find any function for this. Can anyone help me to extract the details? 2016-09-15T23:45:22.943762Z 2016-09

Extracting data from ELB log date format

2016-09-21 Thread Manish Rangari
Guys, I am trying to extract date, time, month, minute etc from below timestamp format but did not find any function for this. Can anyone help me to extract the details? 2016-09-15T23:45:22.943762Z 2016-09-15T23:45:22.948829Z --Manish