I don't really see the problem, i selected my newindex ( it exsists in my
mapping with my types)
PUT /newindex/
PUT /_river/newindex/_mapping
{
"newindex" : {
"properties": {
"marques": {"type": "string"},
"ventes": {"type": "long"},
"mois":{"type": "date"}
}
}
}
PUT /_river/newindex/_meta
{
"type": "csv",
"csv_file": {
"folder": "E:/elasticsearch-1.2.2/tmp",
"poll": "5m",
"first_line_is_header":"true",
"field_separator": ";",
"escape_character": " ",
"quote_character": "'"
}
,
"index" : {
"index" : "newindex",
"type" : "newindex",
"bulk_size" : 100,
"bulk_threshold" : 10
}
}
In addition, when i create the newindex it showed {
"_index": "_river",
"_type": "newindex",
"_id": "_meta",
"_version": 1,
"created": true
}
newindex exists in _river with correct types
On Wednesday, July 30, 2014 2:06:50 PM UTC+2, David Pilato wrote:
>
> That's the problem.
>
> A River creates documents in another index than _river.
>
> If I look at the river documentation, you can set it using:
>
> "index" : {
> "index" : "my_csv_data",
> "type" : "csv_type",
> "bulk_size" : 100,
> "bulk_threshold" : 10
> }
>
> So basically, you need to define your aping for index my_csv_data and type
> csv_type
>
> See https://github.com/AgileWorksOrg/elasticsearch-river-csv#full-request
>
>
> --
> *David Pilato* | *Technical Advocate* | *Elasticsearch.com*
> @dadoonet <https://twitter.com/dadoonet> | @elasticsearchfr
> <https://twitter.com/elasticsearchfr>
>
>
> Le 30 juillet 2014 à 13:54:53, Amirah ([email protected] <javascript:>)
> a écrit:
>
> there is a missing part ( copy paste error) /_river/
> So, yes i use this
> PUT /_river/newindex/_mapping
> {
> "newindex" : {
>
> "properties": {
> "MyStringValue": {"type": "string"},
> "MyLongValue": {"type": "long"},
> "MyDateValue":{"type": "date"}
> }
> }
> }
>
> }
>
> to create the mapping, my variables ( type names ) are : *MyStringValue*
> and its type is *String*, *MyLongValue* and its type is *long*,
> *MyDateValue* and its type is *date*.
> It creates the mapping ( i already checked using GET _mapping ) it exists
> with my real types ! but once i use my csv file, it changes to string
> everywhere!
>
>
>
> On Wednesday, July 30, 2014 12:34:25 PM UTC+2, David Pilato wrote:
>>
>> This looks strange to me
>>
>> PUT /newindex/_mapping
>> {
>> "newindex" : {
>>
>> "properties": {
>> "MyStringValue": {"type": "string"},
>> "MyLongValue": {"type": "long"},
>> "MyDateValue":{"type": "date"}
>> }
>> }
>> }
>>
>> }
>>
>> What is your type name?
>>
>> --
>> *David Pilato* | *Technical Advocate* | *Elasticsearch.com*
>> @dadoonet <https://twitter.com/dadoonet> | @elasticsearchfr
>> <https://twitter.com/elasticsearchfr>
>>
>>
>> Le 30 juillet 2014 à 11:14:42, Amirah ([email protected]) a écrit:
>>
>> Thanks for the answer,
>> Am creating and defining my mapping ( and index) as following :
>>
>>
>> PUT /newindex/
>>
>> PUT /newindex/_mapping
>> {
>> "newindex" : {
>>
>> "properties": {
>> "MyStringValue": {"type": "string"},
>> "MyLongValue": {"type": "long"},
>> "MyDateValue":{"type": "date"}
>> }
>> }
>> }
>>
>> }
>> PUT /_river/newindex/_meta
>> {
>> "type": "csv",
>> "csv_file": {
>> "folder": "E:/elasticsearch-1.2.2/tmp",
>> "poll": "5m",
>> "first_line_is_header":"true",
>> "field_separator": ";",
>> "escape_character": " ",
>> "quote_character": "'"
>> }
>> }
>>
>> and am always getting string in all types ( except date as i put the
>> right format in my csv file *( 2014-07-24T13:58:25.000Z)*
>>
>> any idea ?
>>
>>
>> On Wednesday, July 30, 2014 10:47:13 AM UTC+2, David Pilato wrote:
>>>
>>> I think you are doing something wrong.
>>> If you defined a mapping it should not be overwritten by the CSV river
>>> as far as I know.
>>> Enter code here...
>>>
>>>
>>>
>>
>>
>>
>>
>>> --
>>> *David Pilato* | *Technical Advocate* | *Elasticsearch.com*
>>> @dadoonet <https://twitter.com/dadoonet> | @elasticsearchfr
>>> <https://twitter.com/elasticsearchfr>
>>>
>>>
>>> Le 30 juillet 2014 à 10:31:07, Amirah ([email protected]) a écrit:
>>>
>>> Hello,
>>>
>>> Am trying to create an index using "CSV River Plugin for ElasticSearch"
>>> <https://github.com/AgileWorksOrg/elasticsearch-river-csv>, my csv file
>>> contains *String*, *long* and *date* values.
>>>
>>> My problem is :
>>> - ElasticSearch always consider *long* values as *string* ( with
>>> default mapping ) and when i try to create a specific mapping to be used,
>>> it changes *long* type to *string* type.
>>> - So, is there a way to tell ElasticSearch *Don't map everything as
>>> string *?
>>>
>>> Any suggestion please?
>>>
>>> Thank you
>>>
>>>
>>> --
>>> 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 [email protected].
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/elasticsearch/664de1fc-1e52-4846-9660-5f5808d7b6af%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/elasticsearch/664de1fc-1e52-4846-9660-5f5808d7b6af%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 [email protected].
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/elasticsearch/69675304-f587-4ad2-b24c-550be4446039%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/elasticsearch/69675304-f587-4ad2-b24c-550be4446039%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 [email protected] <javascript:>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/elasticsearch/e8a17a8f-a98e-41fa-a774-36cdc0f4b684%40googlegroups.com
>
> <https://groups.google.com/d/msgid/elasticsearch/e8a17a8f-a98e-41fa-a774-36cdc0f4b684%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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/1db22392-4c77-49ca-97d9-f669d47da861%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
