As I mentioned at the title of this question, I wonder is there a way
to convert @timestamp of ES to Unix epoch time in milliseconds by
using ES query?
For instance, "2014-11-10T15:00:00.000Z" to "1415599200000".
Any help will be great.
As I mentioned at the title of this question, I wonder is there a way
to convert @timestamp of ES to Unix epoch time in milliseconds by
using ES query?
For instance, "2014-11-10T15:00:00.000Z" to "1415599200000".
Any help will be great.
I still want to know how to get epoch time from @timestamp by using query.
I mean I want a query result like below.
Suppose the "unixtime'' is not a indexed field and converted from @timestamp.
As I mentioned at the title of this question, I wonder is there a way
to convert @timestamp of ES to Unix epoch time in milliseconds by
using ES query?
For instance, "2014-11-10T15:00:00.000Z" to "1415599200000".
Any help will be great.
I still want to know how to get epoch time from @timestamp by using query.
I mean I want a query result like below.
Suppose the "unixtime'' is not a indexed field and converted from @timestamp.
As I mentioned at the title of this question, I wonder is there a way
to convert @timestamp of ES to Unix epoch time in milliseconds by
using ES query?
For instance, "2014-11-10T15:00:00.000Z" to "1415599200000".
Any help will be great.
First of all, thanks your advice.
And what I am trying to do is use the @timestamp of ES, includes
milliseconds, in hive while using elasticsearch-hadoop.
The problem is the timestamp type of hive, which is in seconds, can not help me.
So, I just want to figure out how many options do I have, and choose
one of them to solve my problem.
Thank you again.
mungeol
On Fri, Dec 5, 2014 at 6:14 PM, David Pilato david@pilato.fr wrote:
You should try to add store: true in your mapping for this field and ask for it as a field in the search query. I think this should work.
Still I don't understand what you are trying to do? Do you want to compute anything based on that?
I still want to know how to get epoch time from @timestamp by using query.
I mean I want a query result like below.
Suppose the "unixtime'' is not a indexed field and converted from @timestamp.
As I mentioned at the title of this question, I wonder is there a way
to convert @timestamp of ES to Unix epoch time in milliseconds by
using ES query?
For instance, "2014-11-10T15:00:00.000Z" to "1415599200000".
Any help will be great.
First of all, thanks your advice.
And what I am trying to do is use the @timestamp of ES, includes
milliseconds, in hive while using elasticsearch-hadoop.
The problem is the timestamp type of hive, which is in seconds, can not help me.
So, I just want to figure out how many options do I have, and choose
one of them to solve my problem.
Thank you again.
mungeol
On Fri, Dec 5, 2014 at 6:14 PM, David Pilato david@pilato.fr wrote:
You should try to add store: true in your mapping for this field and ask for it as a field in the search query. I think this should work.
Still I don't understand what you are trying to do? Do you want to compute anything based on that?
I still want to know how to get epoch time from @timestamp by using query.
I mean I want a query result like below.
Suppose the "unixtime'' is not a indexed field and converted from @timestamp.
As I mentioned at the title of this question, I wonder is there a way
to convert @timestamp of ES to Unix epoch time in milliseconds by
using ES query?
For instance, "2014-11-10T15:00:00.000Z" to "1415599200000".
Any help will be great.
To be honest, I already have several ways to solve my problem.
For now, one of the best solutions is using a customized hive UDF
which converts time string with given pattern to unix time stamp in
milliseconds.
And, I am seeking another way at ES side which makes me have one more
option to choose, so I can finally decide the best way to use.
As far as I know, there is no much help I can seek from
elasticsearch-hadoop itself.
Again, Thank you so much.
Mungeol
On Mon, Dec 8, 2014 at 12:20 PM, David Pilato david@pilato.fr wrote:
IMHO you'd better ask "how I can transform an elasticsearch date field into typestamp field in Hive using elasticsearch-hadoop?"
I'm pretty sure there are some es-hadoop experts who can give you some advices.
First of all, thanks your advice.
And what I am trying to do is use the @timestamp of ES, includes
milliseconds, in hive while using elasticsearch-hadoop.
The problem is the timestamp type of hive, which is in seconds, can not help me.
So, I just want to figure out how many options do I have, and choose
one of them to solve my problem.
Thank you again.
mungeol
On Fri, Dec 5, 2014 at 6:14 PM, David Pilato david@pilato.fr wrote:
You should try to add store: true in your mapping for this field and ask for it as a field in the search query. I think this should work.
Still I don't understand what you are trying to do? Do you want to compute anything based on that?
I still want to know how to get epoch time from @timestamp by using query.
I mean I want a query result like below.
Suppose the "unixtime'' is not a indexed field and converted from @timestamp.
As I mentioned at the title of this question, I wonder is there a way
to convert @timestamp of ES to Unix epoch time in milliseconds by
using ES query?
For instance, "2014-11-10T15:00:00.000Z" to "1415599200000".
Any help will be great.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.