In my mysql table (type : datetime) :
| date_source |
+---------------------+
| 2008-09-15 18:29:07 |
| 2013-08-29 00:00:00 |
| 2013-07-04 00:00:00 |
| 2013-07-17 00:00:00 |
| 2013-07-17 00:00:00 |
| 0000-00-00 00:00:00 |
...
If I use a mapping (type :string)
And I index :
PUT /_river/test/_meta
{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://ip:port/database",
"user" : "user",
"password" : "password",
"sql" : "select id_source as _id, title_source, date_source from
source", *// if I add this "where date_source not like '%0000%'", it's
work but values miss for this date*
"index" : "test",
"type" : "source",
"max_bulk_requests" : 5
}}
Le mercredi 2 juillet 2014 12:09:58 UTC+2, vineeth mohan a écrit :
>
> Hi Tanguy ,
>
> How is this a valid date string - "java.io.IOException:
> java.sql.SQLException: Value '79180000-00-00 00:00:00 " ?
> This value cant be mapped to any date format or is valid in anyway.
>
> Thanks
> Vineth
>
>
>
>
> On Wed, Jul 2, 2014 at 3:21 PM, Tanguy Bernard <bernardt...@gmail.com
> <javascript:>> wrote:
>
>> As made, when I index date 0000-00-00 00:00:00 the indexing stop
>> completly with an error. (the begin work and stop instantly)
>> I have tried to put (mapping) the type : string to my date but it doesn't
>> work
>>
>> Have you an idea to solve my problem ?
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "elasticsearch" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to elasticsearc...@googlegroups.com <javascript:>.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/elasticsearch/57d83657-a032-4ed8-8236-143a8e44c5fc%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/elasticsearch/57d83657-a032-4ed8-8236-143a8e44c5fc%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/1fc6c18b-a192-4972-92b6-9210be9c46aa%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
