Property DataType - apoc.meta.type

-

Node Properties in Neo4j.

A property can be of any datatype even within nodes of the same label. Nodes have no fixed schema as with the RDBMS where most notions of data storage are formed and 'best practice' is enforced. 

Properties themselves do not have types, but the values they hold do. However, you can have a property, X which could be assigned a string value or a numeric value. There is no enforcement of typing for a property. Of course, it would not (always) make sense to assign a property different type values in your graph.

So, just what datatype is the property?

Trusty APOC has a function for that.

WITH [true, 42, 'foo', 1.2] AS data UNWIND data as value RETURN apoc.meta.type(value)

So, just what datatype is the property?

"BOOLEAN" "INTEGER" "STRING" "FLOAT"

You can use this function in MATCHES on nodes in your system where properties are unknown at runtime.

MATCH (n:MyNode) RETURN apoc.meta.type(n.MyProperty)

Comments

Post a Comment

Popular posts from this blog

Stopping and Starting the Neo4j Database

-
Controlling the service System services are controlled with the systemctl command. It accepts a number of commands and follows the format: systemctl {start|stop|restart} neo4j you may find that you need to prefix the systemctl command with sudo like: sudo systemctl stop neo4j looking at the output of the status command we get :   sudo systemctl status neo4j ● neo4j.service - Neo4j Graph Database    Loaded: loaded (/etc/systemd/system/neo4j.service; enabled; vendor preset: enabled)    Active: active (running) since Thu 2020-07-23 09:53:29 UTC; 1h 33min ago  Main PID: 958 (pre-neo4j.sh)     Tasks: 64    Memory: 14.3G       CPU: 22min 1.740s    CGroup: /system.slice/neo4j.service            ├─ 958 /bin/bash /etc/neo4j/pre-neo4j.sh            ├─ 996 /bin/sh /etc/neo4j/reset-password-aws.sh            ├─ 997 /usr/bin/java -cp /va...
Read more

NULLS in Neo4j

-
From the documentation NULLs in Neo4j are explained as. null is used to represent missing/undefined values. null is not equal to null . Not knowing two values does not imply that they are the same value. So the expression null = null yields null and not true . To check if an expression is null , use IS NULL . Arithmetic expressions, comparisons and function calls (except coalesce ) will return null if any argument is null . An attempt to access a missing element in a list or a property that doesn’t exist yields null . In OPTIONAL MATCH clauses, null s will be used for missing parts of the pattern. All very neat and dry and abstract. NULLS are undefined, they have no value that can be determined. In Neo4j, only non-null properties are stored. A different concept to the traditional database way of looking at the world. Each Node, of the same label, can have entirely different properties, and will have null return values where no determinable value for a property has been...
Read more