Defining Data Type for a property

[Murray Bryant]

I am getting an error when creating a property on a node.

The data is a mix of numeric and text in the column.

The error is

Thread 41: Values for result_text have inconsistent types. Expected type: Long, but current value is "3.34" at row 266518

Is is possible to force the data type of the property?

[Vince Bickers]

Yes, you can use one of the built-in converters. In this case, your data is actually real-valued but the first few rows looked like integers, which is why you get the warning. So:

"properties" : [
   { "name": "result_text",  "convert": "real" }
]

[Vince Bickers]

Closing this, please re-open if it doesn't resolve the problem.

[Murray Bryant]

Vince is there a list of the available converters somewhere in the wiki?

[Vince Bickers]

There is

https://bitbucket.org/vbickers/neo4j-databridge/wiki/5.2%20Use%20data%20converters.md#!52-use-data-converters

and

https://bitbucket.org/vbickers/neo4j-databridge/wiki/5.3%20Create%20a%20custom%20data%20converter

The first page could probably do with some explicit examples of each type, but if you read the entire page, it should be clear enough hopefully. In any case let me know if you have any questions.