This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/incubator-age-website.git
The following commit(s) were added to refs/heads/asf-site by this push:
new c44b2c2 deploy: 5bed73c5cdab7af74005e05af708ddce385e82a4
c44b2c2 is described below
commit c44b2c2290bd6d11c3b81b8952bed34b097c5de4
Author: JoshInnis <[email protected]>
AuthorDate: Tue Mar 29 20:01:42 2022 +0000
deploy: 5bed73c5cdab7af74005e05af708ddce385e82a4
---
docs/master/.buildinfo | 2 +-
docs/master/.doctrees/advanced/advanced.doctree | Bin 17332 -> 17332 bytes
.../.doctrees/advanced/advanced_overview.doctree | Bin 3665 -> 3665 bytes
docs/master/.doctrees/advanced/plpgsql.doctree | Bin 11076 -> 11076 bytes
.../.doctrees/advanced/prepared_statements.doctree | Bin 8572 -> 8572 bytes
.../.doctrees/advanced/sql_in_cypher.doctree | Bin 5905 -> 5905 bytes
docs/master/.doctrees/clauses/create.doctree | Bin 20453 -> 20453 bytes
docs/master/.doctrees/clauses/delete.doctree | Bin 11222 -> 11222 bytes
docs/master/.doctrees/clauses/limit.doctree | Bin 7427 -> 7427 bytes
docs/master/.doctrees/clauses/match.doctree | Bin 31942 -> 31942 bytes
docs/master/.doctrees/clauses/order_by.doctree | Bin 15347 -> 15347 bytes
docs/master/.doctrees/clauses/remove.doctree | Bin 6630 -> 6630 bytes
docs/master/.doctrees/clauses/return.doctree | Bin 21591 -> 21591 bytes
docs/master/.doctrees/clauses/set.doctree | Bin 11952 -> 11952 bytes
docs/master/.doctrees/clauses/skip.doctree | Bin 9537 -> 9537 bytes
docs/master/.doctrees/clauses/with.doctree | Bin 11085 -> 11085 bytes
docs/master/.doctrees/environment.pickle | Bin 137225 -> 140399 bytes
.../functions/aggregate_functions.doctree | Bin 57674 -> 57674 bytes
.../.doctrees/functions/list_functions.doctree | Bin 18988 -> 18988 bytes
.../functions/logarithmic_functions.doctree | Bin 16326 -> 16326 bytes
.../.doctrees/functions/numeric_functions.doctree | Bin 22628 -> 22628 bytes
.../functions/predicate_functions.doctree | Bin 7764 -> 7764 bytes
.../.doctrees/functions/scalar_functions.doctree | Bin 56296 -> 56296 bytes
.../.doctrees/functions/string_functions.doctree | Bin 47885 -> 47885 bytes
.../functions/trigonometric_functions.doctree | Bin 34567 -> 34567 bytes
.../.doctrees/functions/user_functions.doctree | Bin 4976 -> 4976 bytes
docs/master/.doctrees/index.doctree | Bin 4122 -> 4142 bytes
docs/master/.doctrees/intro/aggregation.doctree | Bin 27322 -> 27322 bytes
docs/master/.doctrees/intro/agload.doctree | Bin 0 -> 31310 bytes
docs/master/.doctrees/intro/comparability.doctree | Bin 32523 -> 32523 bytes
docs/master/.doctrees/intro/cypher.doctree | Bin 10246 -> 10246 bytes
docs/master/.doctrees/intro/graphs.doctree | Bin 11554 -> 11554 bytes
docs/master/.doctrees/intro/operators.doctree | Bin 22257 -> 22257 bytes
docs/master/.doctrees/intro/overview.doctree | Bin 4006 -> 4006 bytes
docs/master/.doctrees/intro/precedence.doctree | Bin 7042 -> 7042 bytes
docs/master/.doctrees/intro/setup.doctree | Bin 14235 -> 14235 bytes
docs/master/.doctrees/intro/types.doctree | Bin 81184 -> 81184 bytes
docs/master/_sources/index.rst.txt | 1 +
docs/master/_sources/intro/agload.md.txt | 158 +++++++
docs/master/advanced/advanced.html | 1 +
docs/master/advanced/advanced_overview.html | 1 +
docs/master/advanced/plpgsql.html | 1 +
docs/master/advanced/prepared_statements.html | 1 +
docs/master/advanced/sql_in_cypher.html | 1 +
docs/master/clauses/create.html | 1 +
docs/master/clauses/delete.html | 1 +
docs/master/clauses/limit.html | 1 +
docs/master/clauses/match.html | 5 +-
docs/master/clauses/order_by.html | 1 +
docs/master/clauses/remove.html | 1 +
docs/master/clauses/return.html | 1 +
docs/master/clauses/set.html | 1 +
docs/master/clauses/skip.html | 1 +
docs/master/clauses/with.html | 1 +
docs/master/functions/aggregate_functions.html | 1 +
docs/master/functions/list_functions.html | 1 +
docs/master/functions/logarithmic_functions.html | 1 +
docs/master/functions/numeric_functions.html | 1 +
docs/master/functions/predicate_functions.html | 1 +
docs/master/functions/scalar_functions.html | 1 +
docs/master/functions/string_functions.html | 1 +
docs/master/functions/trigonometric_functions.html | 1 +
docs/master/functions/user_functions.html | 1 +
docs/master/genindex.html | 1 +
docs/master/index.html | 2 +
docs/master/intro/aggregation.html | 5 +-
docs/master/intro/agload.html | 472 +++++++++++++++++++++
docs/master/intro/comparability.html | 1 +
docs/master/intro/cypher.html | 1 +
docs/master/intro/graphs.html | 1 +
docs/master/intro/operators.html | 1 +
docs/master/intro/overview.html | 1 +
docs/master/intro/precedence.html | 1 +
docs/master/intro/setup.html | 1 +
docs/master/intro/types.html | 1 +
docs/master/objects.inv | Bin 853 -> 879 bytes
docs/master/search.html | 1 +
docs/master/searchindex.js | 2 +-
docs/v0.6.0/.buildinfo | 2 +-
docs/v0.6.0/.doctrees/advanced/advanced.doctree | Bin 17332 -> 17332 bytes
.../.doctrees/advanced/advanced_overview.doctree | Bin 3665 -> 3665 bytes
docs/v0.6.0/.doctrees/advanced/plpgsql.doctree | Bin 4203 -> 4203 bytes
.../.doctrees/advanced/prepared_statements.doctree | Bin 8572 -> 8572 bytes
.../.doctrees/advanced/sql_in_cypher.doctree | Bin 5905 -> 5905 bytes
docs/v0.6.0/.doctrees/clauses/create.doctree | Bin 20453 -> 20453 bytes
docs/v0.6.0/.doctrees/clauses/delete.doctree | Bin 11208 -> 11208 bytes
docs/v0.6.0/.doctrees/clauses/limit.doctree | Bin 7427 -> 7427 bytes
docs/v0.6.0/.doctrees/clauses/match.doctree | Bin 25090 -> 25090 bytes
docs/v0.6.0/.doctrees/clauses/order_by.doctree | Bin 15347 -> 15347 bytes
docs/v0.6.0/.doctrees/clauses/remove.doctree | Bin 6630 -> 6630 bytes
docs/v0.6.0/.doctrees/clauses/return.doctree | Bin 21591 -> 21591 bytes
docs/v0.6.0/.doctrees/clauses/set.doctree | Bin 11952 -> 11952 bytes
docs/v0.6.0/.doctrees/clauses/skip.doctree | Bin 9537 -> 9537 bytes
docs/v0.6.0/.doctrees/clauses/with.doctree | Bin 11085 -> 11085 bytes
docs/v0.6.0/.doctrees/environment.pickle | Bin 136659 -> 136659 bytes
.../functions/aggregate_functions.doctree | Bin 57674 -> 57674 bytes
.../.doctrees/functions/list_functions.doctree | Bin 18988 -> 18988 bytes
.../functions/logarithmic_functions.doctree | Bin 16326 -> 16326 bytes
.../.doctrees/functions/numeric_functions.doctree | Bin 22628 -> 22628 bytes
.../functions/predicate_functions.doctree | Bin 6445 -> 6445 bytes
.../.doctrees/functions/scalar_functions.doctree | Bin 56296 -> 56296 bytes
.../.doctrees/functions/string_functions.doctree | Bin 47885 -> 47885 bytes
.../functions/trigonometric_functions.doctree | Bin 34567 -> 34567 bytes
.../.doctrees/functions/user_functions.doctree | Bin 4976 -> 4976 bytes
docs/v0.6.0/.doctrees/index.doctree | Bin 4122 -> 4122 bytes
docs/v0.6.0/.doctrees/intro/aggregation.doctree | Bin 27322 -> 27322 bytes
docs/v0.6.0/.doctrees/intro/comparability.doctree | Bin 32523 -> 32523 bytes
docs/v0.6.0/.doctrees/intro/cypher.doctree | Bin 10246 -> 10246 bytes
docs/v0.6.0/.doctrees/intro/graphs.doctree | Bin 11554 -> 11554 bytes
docs/v0.6.0/.doctrees/intro/operators.doctree | Bin 22257 -> 22257 bytes
docs/v0.6.0/.doctrees/intro/overview.doctree | Bin 4006 -> 4006 bytes
docs/v0.6.0/.doctrees/intro/precedence.doctree | Bin 7042 -> 7042 bytes
docs/v0.6.0/.doctrees/intro/setup.doctree | Bin 11024 -> 11024 bytes
docs/v0.6.0/.doctrees/intro/types.doctree | Bin 81184 -> 81184 bytes
114 files changed, 675 insertions(+), 7 deletions(-)
diff --git a/docs/master/.buildinfo b/docs/master/.buildinfo
index 8be0b7f..df826f5 100644
--- a/docs/master/.buildinfo
+++ b/docs/master/.buildinfo
@@ -1,4 +1,4 @@
# Sphinx build info version 1
# This file hashes the configuration used when building these files. When it
is not found, a full rebuild will be done.
-config: 40a2666a9bf765b23263dfc592151c1f
+config: 046b0b2979798a87c18d1ad8c211440e
tags: 645f666f9bcd5a90fca523b33c5a78b7
diff --git a/docs/master/.doctrees/advanced/advanced.doctree
b/docs/master/.doctrees/advanced/advanced.doctree
index 23b6269..461b5c4 100644
Binary files a/docs/master/.doctrees/advanced/advanced.doctree and
b/docs/master/.doctrees/advanced/advanced.doctree differ
diff --git a/docs/master/.doctrees/advanced/advanced_overview.doctree
b/docs/master/.doctrees/advanced/advanced_overview.doctree
index 464ee31..4ddcd7b 100644
Binary files a/docs/master/.doctrees/advanced/advanced_overview.doctree and
b/docs/master/.doctrees/advanced/advanced_overview.doctree differ
diff --git a/docs/master/.doctrees/advanced/plpgsql.doctree
b/docs/master/.doctrees/advanced/plpgsql.doctree
index f698157..833729a 100644
Binary files a/docs/master/.doctrees/advanced/plpgsql.doctree and
b/docs/master/.doctrees/advanced/plpgsql.doctree differ
diff --git a/docs/master/.doctrees/advanced/prepared_statements.doctree
b/docs/master/.doctrees/advanced/prepared_statements.doctree
index 6331bad..90e2205 100644
Binary files a/docs/master/.doctrees/advanced/prepared_statements.doctree and
b/docs/master/.doctrees/advanced/prepared_statements.doctree differ
diff --git a/docs/master/.doctrees/advanced/sql_in_cypher.doctree
b/docs/master/.doctrees/advanced/sql_in_cypher.doctree
index c0217ca..bc471aa 100644
Binary files a/docs/master/.doctrees/advanced/sql_in_cypher.doctree and
b/docs/master/.doctrees/advanced/sql_in_cypher.doctree differ
diff --git a/docs/master/.doctrees/clauses/create.doctree
b/docs/master/.doctrees/clauses/create.doctree
index 2cc1f8f..46802ac 100644
Binary files a/docs/master/.doctrees/clauses/create.doctree and
b/docs/master/.doctrees/clauses/create.doctree differ
diff --git a/docs/master/.doctrees/clauses/delete.doctree
b/docs/master/.doctrees/clauses/delete.doctree
index f612741..ac9fb43 100644
Binary files a/docs/master/.doctrees/clauses/delete.doctree and
b/docs/master/.doctrees/clauses/delete.doctree differ
diff --git a/docs/master/.doctrees/clauses/limit.doctree
b/docs/master/.doctrees/clauses/limit.doctree
index 6de447f..6d60b89 100644
Binary files a/docs/master/.doctrees/clauses/limit.doctree and
b/docs/master/.doctrees/clauses/limit.doctree differ
diff --git a/docs/master/.doctrees/clauses/match.doctree
b/docs/master/.doctrees/clauses/match.doctree
index 79a6a81..71b3bf0 100644
Binary files a/docs/master/.doctrees/clauses/match.doctree and
b/docs/master/.doctrees/clauses/match.doctree differ
diff --git a/docs/master/.doctrees/clauses/order_by.doctree
b/docs/master/.doctrees/clauses/order_by.doctree
index c0dd0ea..c74f6ce 100644
Binary files a/docs/master/.doctrees/clauses/order_by.doctree and
b/docs/master/.doctrees/clauses/order_by.doctree differ
diff --git a/docs/master/.doctrees/clauses/remove.doctree
b/docs/master/.doctrees/clauses/remove.doctree
index a4e7760..b4a79a0 100644
Binary files a/docs/master/.doctrees/clauses/remove.doctree and
b/docs/master/.doctrees/clauses/remove.doctree differ
diff --git a/docs/master/.doctrees/clauses/return.doctree
b/docs/master/.doctrees/clauses/return.doctree
index a0a3b56..b27a0b6 100644
Binary files a/docs/master/.doctrees/clauses/return.doctree and
b/docs/master/.doctrees/clauses/return.doctree differ
diff --git a/docs/master/.doctrees/clauses/set.doctree
b/docs/master/.doctrees/clauses/set.doctree
index 4e1f081..e15c4a8 100644
Binary files a/docs/master/.doctrees/clauses/set.doctree and
b/docs/master/.doctrees/clauses/set.doctree differ
diff --git a/docs/master/.doctrees/clauses/skip.doctree
b/docs/master/.doctrees/clauses/skip.doctree
index 26db5a9..54204f2 100644
Binary files a/docs/master/.doctrees/clauses/skip.doctree and
b/docs/master/.doctrees/clauses/skip.doctree differ
diff --git a/docs/master/.doctrees/clauses/with.doctree
b/docs/master/.doctrees/clauses/with.doctree
index 9c9ef07..c96292e 100644
Binary files a/docs/master/.doctrees/clauses/with.doctree and
b/docs/master/.doctrees/clauses/with.doctree differ
diff --git a/docs/master/.doctrees/environment.pickle
b/docs/master/.doctrees/environment.pickle
index 1041f42..0fa703f 100644
Binary files a/docs/master/.doctrees/environment.pickle and
b/docs/master/.doctrees/environment.pickle differ
diff --git a/docs/master/.doctrees/functions/aggregate_functions.doctree
b/docs/master/.doctrees/functions/aggregate_functions.doctree
index 6068e01..c343e65 100644
Binary files a/docs/master/.doctrees/functions/aggregate_functions.doctree and
b/docs/master/.doctrees/functions/aggregate_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/list_functions.doctree
b/docs/master/.doctrees/functions/list_functions.doctree
index 7f4e12a..82ede32 100644
Binary files a/docs/master/.doctrees/functions/list_functions.doctree and
b/docs/master/.doctrees/functions/list_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/logarithmic_functions.doctree
b/docs/master/.doctrees/functions/logarithmic_functions.doctree
index 9b7b656..4f76edd 100644
Binary files a/docs/master/.doctrees/functions/logarithmic_functions.doctree
and b/docs/master/.doctrees/functions/logarithmic_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/numeric_functions.doctree
b/docs/master/.doctrees/functions/numeric_functions.doctree
index fabcd2b..bfb0262 100644
Binary files a/docs/master/.doctrees/functions/numeric_functions.doctree and
b/docs/master/.doctrees/functions/numeric_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/predicate_functions.doctree
b/docs/master/.doctrees/functions/predicate_functions.doctree
index 7e2e22a..fb92dfe 100644
Binary files a/docs/master/.doctrees/functions/predicate_functions.doctree and
b/docs/master/.doctrees/functions/predicate_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/scalar_functions.doctree
b/docs/master/.doctrees/functions/scalar_functions.doctree
index c0ebd72..dd83d9a 100644
Binary files a/docs/master/.doctrees/functions/scalar_functions.doctree and
b/docs/master/.doctrees/functions/scalar_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/string_functions.doctree
b/docs/master/.doctrees/functions/string_functions.doctree
index 4c5df36..3299c61 100644
Binary files a/docs/master/.doctrees/functions/string_functions.doctree and
b/docs/master/.doctrees/functions/string_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/trigonometric_functions.doctree
b/docs/master/.doctrees/functions/trigonometric_functions.doctree
index d888bee..6bd053a 100644
Binary files a/docs/master/.doctrees/functions/trigonometric_functions.doctree
and b/docs/master/.doctrees/functions/trigonometric_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/user_functions.doctree
b/docs/master/.doctrees/functions/user_functions.doctree
index 1aceeef..34a1b63 100644
Binary files a/docs/master/.doctrees/functions/user_functions.doctree and
b/docs/master/.doctrees/functions/user_functions.doctree differ
diff --git a/docs/master/.doctrees/index.doctree
b/docs/master/.doctrees/index.doctree
index eeaa2d8..1cef7ea 100644
Binary files a/docs/master/.doctrees/index.doctree and
b/docs/master/.doctrees/index.doctree differ
diff --git a/docs/master/.doctrees/intro/aggregation.doctree
b/docs/master/.doctrees/intro/aggregation.doctree
index 4aa0374..81f613a 100644
Binary files a/docs/master/.doctrees/intro/aggregation.doctree and
b/docs/master/.doctrees/intro/aggregation.doctree differ
diff --git a/docs/master/.doctrees/intro/agload.doctree
b/docs/master/.doctrees/intro/agload.doctree
new file mode 100644
index 0000000..fac987b
Binary files /dev/null and b/docs/master/.doctrees/intro/agload.doctree differ
diff --git a/docs/master/.doctrees/intro/comparability.doctree
b/docs/master/.doctrees/intro/comparability.doctree
index 925f075..b4587ce 100644
Binary files a/docs/master/.doctrees/intro/comparability.doctree and
b/docs/master/.doctrees/intro/comparability.doctree differ
diff --git a/docs/master/.doctrees/intro/cypher.doctree
b/docs/master/.doctrees/intro/cypher.doctree
index 6bc72db..72665cc 100644
Binary files a/docs/master/.doctrees/intro/cypher.doctree and
b/docs/master/.doctrees/intro/cypher.doctree differ
diff --git a/docs/master/.doctrees/intro/graphs.doctree
b/docs/master/.doctrees/intro/graphs.doctree
index 53025be..c9b8ce9 100644
Binary files a/docs/master/.doctrees/intro/graphs.doctree and
b/docs/master/.doctrees/intro/graphs.doctree differ
diff --git a/docs/master/.doctrees/intro/operators.doctree
b/docs/master/.doctrees/intro/operators.doctree
index 80afa64..ca8c344 100644
Binary files a/docs/master/.doctrees/intro/operators.doctree and
b/docs/master/.doctrees/intro/operators.doctree differ
diff --git a/docs/master/.doctrees/intro/overview.doctree
b/docs/master/.doctrees/intro/overview.doctree
index 1322b46..0e376cb 100644
Binary files a/docs/master/.doctrees/intro/overview.doctree and
b/docs/master/.doctrees/intro/overview.doctree differ
diff --git a/docs/master/.doctrees/intro/precedence.doctree
b/docs/master/.doctrees/intro/precedence.doctree
index 6ad416d..1bf6af5 100644
Binary files a/docs/master/.doctrees/intro/precedence.doctree and
b/docs/master/.doctrees/intro/precedence.doctree differ
diff --git a/docs/master/.doctrees/intro/setup.doctree
b/docs/master/.doctrees/intro/setup.doctree
index 283b14d..2105b4e 100644
Binary files a/docs/master/.doctrees/intro/setup.doctree and
b/docs/master/.doctrees/intro/setup.doctree differ
diff --git a/docs/master/.doctrees/intro/types.doctree
b/docs/master/.doctrees/intro/types.doctree
index 780197c..6c52967 100644
Binary files a/docs/master/.doctrees/intro/types.doctree and
b/docs/master/.doctrees/intro/types.doctree differ
diff --git a/docs/master/_sources/index.rst.txt
b/docs/master/_sources/index.rst.txt
index 109064c..854b1fc 100644
--- a/docs/master/_sources/index.rst.txt
+++ b/docs/master/_sources/index.rst.txt
@@ -14,6 +14,7 @@ Apache AGE's documentation
intro/comparability
intro/operators
intro/aggregation
+ intro/agload
.. toctree::
:caption: Clauses
diff --git a/docs/master/_sources/intro/agload.md.txt
b/docs/master/_sources/intro/agload.md.txt
new file mode 100644
index 0000000..e37595f
--- /dev/null
+++ b/docs/master/_sources/intro/agload.md.txt
@@ -0,0 +1,158 @@
+# Importing graph from files
+You can use the following instructions to create a graph from the files. This
document explains
+- information about the current branch that includes the functions to load
graphs from files
+- explanation of the functions that enable the creation of graphs from files
+- the structure of CSV files that load functions as input, do and do not.
+- A simple source code example to load countries and cities from the files.
+
+## Getting from the current branch
+The current implementation is available on the fork I have created and
currently have not been merged with the main master branch. You can download
the fork from the following. Please make sure that you download
`create-graph-from-files-b1` branch and not some other branch as this has been
specifically prepared for you.
+
+https://github.com/muhammadshoaib/incubator-age/tree/create-graph-from-files-b1
+
+## Load Graph functions
+Following are the details about the functions to create vertices and edges
from the file.
+
+function `load_labels_from_file` is used to load vertices from the CSV files.
+
+```sql
+load_labels_from_file('<graph name>',
+ '<label name>',
+ '<file path>')
+```
+
+By adding the fourth parameter user can exclude the id field. *** Use this
when there is no id field in the file***
+
+```sql
+load_labels_from_file('<graph name>',
+ '<label name>',
+ '<file path>',
+ false)
+```
+
+Function `load_edges_from_file` can be used to load properties from the CSV
file. Please see the file structure in the following.
+
+Note: make sure that ids in the edge file are identical to ones that are in
vertices files.
+
+```sql
+oad_edges_from_file('<graph name>',
+ '<label name>',
+ '<file path>');
+```
+
+## Explanation about the CSV format
+Following is the explanation about the structure for CSV files for vertices
and edges.
+
+- A CSV file for nodes shall be formatted aw following;
+
+| field name | Field description |
+| ---------- | ------------------------------------------------------------ |
+| id | it shall be the first column of the file and all values shall
be a positive integer. This is an optional field when `id_field_exists` is
***false***. However, it should be present when `id_field_exists` is ***not***
set to false. |
+| Properties | all other columns contains the properties for the nodes. Header
row shall contain the name of property |
+
+- Similarly, a CSV file for edges shall be formatted as follows
+
+| field name | Field description
|
+| ----------------- |
------------------------------------------------------------ |
+| start_id | node id of the node from where the edge is stated. This
id shall be present in nodes.csv file. |
+| start_vertex_type | class of the node
|
+| end_id | end id of the node at which the edge shall be terminated
|
+| end_vertex_type | Class of the node
|
+| properties | properties of the edge. the header shall contain the
property name |
+
+example files can be viewed at `regress/age_load/data`
+
+## Example SQL script
+
+- Load and create graph
+```sql
+LOAD 'age';
+
+SET search_path TO ag_catalog;
+SELECT create_graph('agload_test_graph');
+```
+
+- Create label `country` and load vertices from csv file. *** Note this CSV
file has id field ***
+
+```sql
+SELECT create_vlabel('agload_test_graph','Country');
+SELECT load_labels_from_file('agload_test_graph',
+ 'Country',
+ 'age_load/countries.csv');
+```
+
+- Create label `City` and load vertices from csv file. *** Note this CSV file
has id field ***
+
+```sql
+SELECT create_vlabel('agload_test_graph','City');
+SELECT load_labels_from_file('agload_test_graph',
+ 'City',
+ 'age_load/cities.csv');
+```
+
+- Create label `has_city` and load edges from csv file.
+
+```sql
+SELECT create_elabel('agload_test_graph','has_city');
+SELECT load_edges_from_file('agload_test_graph', 'has_city',
+ 'age_load/edges.csv');
+```
+
+- check if the graph has been loaded properly
+
+```sql
+SELECT table_catalog, table_schema, table_name, table_type
+FROM information_schema.tables
+WHERE table_schema = 'agload_test_graph';
+
+SELECT COUNT(*) FROM agload_test_graph."Country";
+SELECT COUNT(*) FROM agload_test_graph."City";
+SELECT COUNT(*) FROM agload_test_graph."has_city";
+
+SELECT COUNT(*) FROM cypher('agload_test_graph', $$MATCH(n) RETURN n$$) as (n
agtype);
+SELECT COUNT(*) FROM cypher('agload_test_graph', $$MATCH (a)-[e]->(b) RETURN
e$$) as (n agtype);
+```
+
+### Creating vertices without id field in the file.
+
+- Create label `country` and load vertices from csv file. *** Note this CSV
file has no id field ***
+
+```sql
+SELECT create_vlabel('agload_test_graph','Country2');
+SELECT load_labels_from_file('agload_test_graph',
+ 'Country2',
+ 'age_load/countries.csv',
+ false);
+```
+
+- Create label `City` and load vertices from csv file. *** Note this CSV file
has id field ***
+```sql
+SELECT create_vlabel('agload_test_graph','City2');
+SELECT load_labels_from_file('agload_test_graph',
+ 'City2',
+ 'age_load/cities.csv',
+ false);
+```
+- check if the graph has been loaded properly and perform difference analysis
between ids created automatically and picked from the files.
+
+- labels `country` and `city` were created with id field in the file
+- labels `country2` and `city2` were created with no id field in the file.
+```sql
+SELECT COUNT(*) FROM agload_test_graph."Country2";
+SELECT COUNT(*) FROM agload_test_graph."City2";
+
+SELECT id FROM agload_test_graph."Country" LIMIT 10;
+SELECT id FROM agload_test_graph."Country2" LIMIT 10;
+
+SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country {iso2 : 'BE'})
+ RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype, "n.name" agtype,
"n.iso2" agtype);
+SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country2 {iso2 : 'BE'})
+ RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype, "n.name" agtype,
"n.iso2" agtype);
+
+SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country {iso2 : 'AT'})
+ RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype, "n.name" agtype,
"n.iso2" agtype);
+SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country2 {iso2 : 'AT'})
+ RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype, "n.name" agtype,
"n.iso2" agtype);
+
+SELECT drop_graph('agload_test_graph', true);
+```
\ No newline at end of file
diff --git a/docs/master/advanced/advanced.html
b/docs/master/advanced/advanced.html
index e3c867b..47bfcd4 100644
--- a/docs/master/advanced/advanced.html
+++ b/docs/master/advanced/advanced.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/advanced/advanced_overview.html
b/docs/master/advanced/advanced_overview.html
index f0d59d3..95e3095 100644
--- a/docs/master/advanced/advanced_overview.html
+++ b/docs/master/advanced/advanced_overview.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/advanced/plpgsql.html
b/docs/master/advanced/plpgsql.html
index bf6323b..da1a727 100644
--- a/docs/master/advanced/plpgsql.html
+++ b/docs/master/advanced/plpgsql.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/advanced/prepared_statements.html
b/docs/master/advanced/prepared_statements.html
index 2bf34bd..a627e55 100644
--- a/docs/master/advanced/prepared_statements.html
+++ b/docs/master/advanced/prepared_statements.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/advanced/sql_in_cypher.html
b/docs/master/advanced/sql_in_cypher.html
index a71b5d7..89f9647 100644
--- a/docs/master/advanced/sql_in_cypher.html
+++ b/docs/master/advanced/sql_in_cypher.html
@@ -102,6 +102,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/clauses/create.html b/docs/master/clauses/create.html
index 8c1f3c7..e61a800 100644
--- a/docs/master/clauses/create.html
+++ b/docs/master/clauses/create.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul class="current">
diff --git a/docs/master/clauses/delete.html b/docs/master/clauses/delete.html
index a3d01db..fc08233 100644
--- a/docs/master/clauses/delete.html
+++ b/docs/master/clauses/delete.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul class="current">
diff --git a/docs/master/clauses/limit.html b/docs/master/clauses/limit.html
index bb3e2d7..cd8c7bc 100644
--- a/docs/master/clauses/limit.html
+++ b/docs/master/clauses/limit.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul class="current">
diff --git a/docs/master/clauses/match.html b/docs/master/clauses/match.html
index 97d3b8b..7bbc5b4 100644
--- a/docs/master/clauses/match.html
+++ b/docs/master/clauses/match.html
@@ -45,7 +45,7 @@
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
<link rel="next" title="WITH" href="with.html" />
- <link rel="prev" title="Aggregation" href="../intro/aggregation.html" />
+ <link rel="prev" title="Importing graph from files"
href="../intro/agload.html" />
</head>
<body class="wy-body-for-nav">
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul class="current">
@@ -600,7 +601,7 @@ $$) as (r agtype);
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
<a href="with.html" class="btn btn-neutral float-right" title="WITH"
accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"
aria-hidden="true"></span></a>
- <a href="../intro/aggregation.html" class="btn btn-neutral float-left"
title="Aggregation" accesskey="p" rel="prev"><span class="fa
fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
+ <a href="../intro/agload.html" class="btn btn-neutral float-left"
title="Importing graph from files" accesskey="p" rel="prev"><span class="fa
fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
</div>
<hr/>
diff --git a/docs/master/clauses/order_by.html
b/docs/master/clauses/order_by.html
index 6c20fa2..9e73c1f 100644
--- a/docs/master/clauses/order_by.html
+++ b/docs/master/clauses/order_by.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul class="current">
diff --git a/docs/master/clauses/remove.html b/docs/master/clauses/remove.html
index f21eb2d..c2fd3b4 100644
--- a/docs/master/clauses/remove.html
+++ b/docs/master/clauses/remove.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul class="current">
diff --git a/docs/master/clauses/return.html b/docs/master/clauses/return.html
index 94a03d0..455aefd 100644
--- a/docs/master/clauses/return.html
+++ b/docs/master/clauses/return.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul class="current">
diff --git a/docs/master/clauses/set.html b/docs/master/clauses/set.html
index 104a70b..6603371 100644
--- a/docs/master/clauses/set.html
+++ b/docs/master/clauses/set.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul class="current">
diff --git a/docs/master/clauses/skip.html b/docs/master/clauses/skip.html
index 9b17221..ac38ec9 100644
--- a/docs/master/clauses/skip.html
+++ b/docs/master/clauses/skip.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul class="current">
diff --git a/docs/master/clauses/with.html b/docs/master/clauses/with.html
index 797e7d3..c15cd5b 100644
--- a/docs/master/clauses/with.html
+++ b/docs/master/clauses/with.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul class="current">
diff --git a/docs/master/functions/aggregate_functions.html
b/docs/master/functions/aggregate_functions.html
index 96bd9ee..01c80ac 100644
--- a/docs/master/functions/aggregate_functions.html
+++ b/docs/master/functions/aggregate_functions.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/functions/list_functions.html
b/docs/master/functions/list_functions.html
index 5f165f4..023dd73 100644
--- a/docs/master/functions/list_functions.html
+++ b/docs/master/functions/list_functions.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/functions/logarithmic_functions.html
b/docs/master/functions/logarithmic_functions.html
index 020f49f..15c5b10 100644
--- a/docs/master/functions/logarithmic_functions.html
+++ b/docs/master/functions/logarithmic_functions.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/functions/numeric_functions.html
b/docs/master/functions/numeric_functions.html
index fb8e0e3..a728e57 100644
--- a/docs/master/functions/numeric_functions.html
+++ b/docs/master/functions/numeric_functions.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/functions/predicate_functions.html
b/docs/master/functions/predicate_functions.html
index a6e2ebc..93186a6 100644
--- a/docs/master/functions/predicate_functions.html
+++ b/docs/master/functions/predicate_functions.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/functions/scalar_functions.html
b/docs/master/functions/scalar_functions.html
index 6c31667..bb17aa7 100644
--- a/docs/master/functions/scalar_functions.html
+++ b/docs/master/functions/scalar_functions.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/functions/string_functions.html
b/docs/master/functions/string_functions.html
index 3734c06..81e9798 100644
--- a/docs/master/functions/string_functions.html
+++ b/docs/master/functions/string_functions.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/functions/trigonometric_functions.html
b/docs/master/functions/trigonometric_functions.html
index 8b72c4a..590d351 100644
--- a/docs/master/functions/trigonometric_functions.html
+++ b/docs/master/functions/trigonometric_functions.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/functions/user_functions.html
b/docs/master/functions/user_functions.html
index 71691f9..e727b81 100644
--- a/docs/master/functions/user_functions.html
+++ b/docs/master/functions/user_functions.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="../intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/genindex.html b/docs/master/genindex.html
index 4bb6df7..145f91e 100644
--- a/docs/master/genindex.html
+++ b/docs/master/genindex.html
@@ -101,6 +101,7 @@
<li class="toctree-l1"><a class="reference internal"
href="intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/index.html b/docs/master/index.html
index e4b6ddc..ab94bfd 100644
--- a/docs/master/index.html
+++ b/docs/master/index.html
@@ -102,6 +102,7 @@
<li class="toctree-l1"><a class="reference internal"
href="intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
@@ -219,6 +220,7 @@
<li class="toctree-l1"><a class="reference internal"
href="intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="intro/agload.html">Importing graph from files</a></li>
</ul>
</div>
<div class="toctree-wrapper compound">
diff --git a/docs/master/intro/aggregation.html
b/docs/master/intro/aggregation.html
index 091250e..bd79015 100644
--- a/docs/master/intro/aggregation.html
+++ b/docs/master/intro/aggregation.html
@@ -44,7 +44,7 @@
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
- <link rel="next" title="MATCH" href="../clauses/match.html" />
+ <link rel="next" title="Importing graph from files" href="agload.html" />
<link rel="prev" title="Operators" href="operators.html" />
</head>
@@ -117,6 +117,7 @@
</li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal"
href="agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
@@ -490,7 +491,7 @@ $$) as (a agtype);
</div>
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
- <a href="../clauses/match.html" class="btn btn-neutral float-right"
title="MATCH" accesskey="n" rel="next">Next <span class="fa
fa-arrow-circle-right" aria-hidden="true"></span></a>
+ <a href="agload.html" class="btn btn-neutral float-right"
title="Importing graph from files" accesskey="n" rel="next">Next <span
class="fa fa-arrow-circle-right" aria-hidden="true"></span></a>
<a href="operators.html" class="btn btn-neutral float-left"
title="Operators" accesskey="p" rel="prev"><span class="fa
fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
</div>
diff --git a/docs/master/intro/agload.html b/docs/master/intro/agload.html
new file mode 100644
index 0000000..b29f897
--- /dev/null
+++ b/docs/master/intro/agload.html
@@ -0,0 +1,472 @@
+
+
+<!DOCTYPE html>
+<html class="writer-html5" lang="en" >
+<head>
+ <meta charset="utf-8" />
+
+ <meta name="viewport" content="width=device-width, initial-scale=1.0" />
+
+ <title>Importing graph from files — Apache AGE master
documentation</title>
+
+
+
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+ <link rel="stylesheet" href="../_static/pygments.css" type="text/css" />
+ <link rel="stylesheet" href="../_static/pygments.css" type="text/css" />
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+ <link rel="stylesheet" href="../_static/css/custom.css" type="text/css" />
+
+
+
+ <link rel="shortcut icon" href="../_static/favicon.ico"/>
+
+
+
+
+
+
+
+
+ <!--[if lt IE 9]>
+ <script src="../_static/js/html5shiv.min.js"></script>
+ <![endif]-->
+
+
+ <script type="text/javascript" id="documentation_options"
data-url_root="../" src="../_static/documentation_options.js"></script>
+ <script data-url_root="../" id="documentation_options"
src="../_static/documentation_options.js"></script>
+ <script src="../_static/jquery.js"></script>
+ <script src="../_static/underscore.js"></script>
+ <script src="../_static/doctools.js"></script>
+
+ <script type="text/javascript" src="../_static/js/theme.js"></script>
+
+
+ <link rel="index" title="Index" href="../genindex.html" />
+ <link rel="search" title="Search" href="../search.html" />
+ <link rel="next" title="MATCH" href="../clauses/match.html" />
+ <link rel="prev" title="Aggregation" href="aggregation.html" />
+</head>
+
+<body class="wy-body-for-nav">
+
+
+ <div class="wy-grid-for-nav">
+
+ <nav data-toggle="wy-nav-shift" class="wy-nav-side">
+ <div class="wy-side-scroll">
+ <div class="wy-side-nav-search" >
+
+
+
+ <a href="../index.html" class="icon icon-home"> Apache AGE
+
+
+
+
+ <img src="../_static/logo.png" class="logo" alt="Logo"/>
+
+ </a>
+
+
+
+
+
+
+
+<div role="search">
+ <form id="rtd-search-form" class="wy-form" action="../search.html"
method="get">
+ <input type="text" name="q" placeholder="Search docs" />
+ <input type="hidden" name="check_keywords" value="yes" />
+ <input type="hidden" name="area" value="default" />
+ </form>
+</div>
+
+
+ </div>
+
+
+ <div class="wy-menu wy-menu-vertical" data-spy="affix"
role="navigation" aria-label="main navigation">
+
+
+
+
+
+
+ <p class="caption" role="heading"><span
class="caption-text">Introduction</span></p>
+<ul class="current">
+<li class="toctree-l1"><a class="reference internal"
href="overview.html">Overview</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="setup.html">Setup</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="graphs.html">Graphs</a></li>
+<li class="toctree-l1"><a class="reference internal" href="cypher.html">The
AGE Cypher Query Format</a></li>
+<li class="toctree-l1"><a class="reference internal" href="types.html">Data
Types - An Introduction to agtype</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="operators.html">Operators</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="aggregation.html">Aggregation</a></li>
+<li class="toctree-l1 current"><a class="current reference internal"
href="#">Importing graph from files</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="#getting-from-the-current-branch">Getting from the current branch</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="#load-graph-functions">Load Graph functions</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="#explanation-about-the-csv-format">Explanation about the CSV
format</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="#example-sql-script">Example SQL script</a><ul>
+<li class="toctree-l3"><a class="reference internal"
href="#creating-vertices-without-id-field-in-the-file">Creating vertices
without id field in the file.</a></li>
+</ul>
+</li>
+</ul>
+</li>
+</ul>
+<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
+<ul>
+<li class="toctree-l1"><a class="reference internal"
href="../clauses/match.html">MATCH</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../clauses/with.html">WITH</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../clauses/return.html">RETURN</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../clauses/skip.html">SKIP</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../clauses/limit.html">LIMIT</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../clauses/create.html">CREATE</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../clauses/set.html">SET</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../clauses/remove.html">REMOVE</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../clauses/delete.html">DELETE</a></li>
+</ul>
+<p class="caption" role="heading"><span
class="caption-text">Functions</span></p>
+<ul>
+<li class="toctree-l1"><a class="reference internal"
href="../functions/predicate_functions.html">Predicate Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../functions/scalar_functions.html">Scalar Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../functions/list_functions.html">List Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../functions/numeric_functions.html">Numeric Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../functions/logarithmic_functions.html">Logarithmic Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../functions/trigonometric_functions.html">Trigonometric
Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../functions/string_functions.html">String Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../functions/aggregate_functions.html">Aggregation Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../functions/user_functions.html">User defined functions</a></li>
+</ul>
+<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
+<ul>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
+</ul>
+
+
+
+ </div>
+
+ </div>
+ </nav>
+
+ <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
+
+
+ <nav class="wy-nav-top" aria-label="top navigation">
+
+ <i data-toggle="wy-nav-top" class="fa fa-bars"></i>
+ <a href="../index.html">Apache AGE</a>
+
+ </nav>
+
+
+ <div class="wy-nav-content">
+
+ <div class="rst-content">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+<div role="navigation" aria-label="breadcrumbs navigation">
+
+ <ul class="wy-breadcrumbs">
+
+ <li><a href="../index.html" class="icon icon-home"></a> »</li>
+
+ <li>Importing graph from files</li>
+
+
+ <li class="wy-breadcrumbs-aside">
+
+
+
+ <a
href="https://github.com/apache/incubator-age-website/blob/master/docs/intro/agload.md";
class="fa fa-github"> Edit on GitHub</a>
+
+
+
+ </li>
+
+ </ul>
+
+
+ <hr/>
+</div>
+ <div role="main" class="document" itemscope="itemscope"
itemtype="http://schema.org/Article";>
+ <div itemprop="articleBody">
+
+ <div class="tex2jax_ignore mathjax_ignore section"
id="importing-graph-from-files">
+<h1>Importing graph from files<a class="headerlink"
href="#importing-graph-from-files" title="Permalink to this headline">¶</a></h1>
+<p>You can use the following instructions to create a graph from the files.
This document explains</p>
+<ul class="simple">
+<li><p>information about the current branch that includes the functions to
load graphs from files</p></li>
+<li><p>explanation of the functions that enable the creation of graphs from
files</p></li>
+<li><p>the structure of CSV files that load functions as input, do and do
not.</p></li>
+<li><p>A simple source code example to load countries and cities from the
files.</p></li>
+</ul>
+<div class="section" id="getting-from-the-current-branch">
+<h2>Getting from the current branch<a class="headerlink"
href="#getting-from-the-current-branch" title="Permalink to this
headline">¶</a></h2>
+<p>The current implementation is available on the fork I have created and
currently have not been merged with the main master branch. You can download
the fork from the following. Please make sure that you download <code
class="docutils literal notranslate"><span
class="pre">create-graph-from-files-b1</span></code> branch and not some other
branch as this has been specifically prepared for you.</p>
+<p>https://github.com/muhammadshoaib/incubator-age/tree/create-graph-from-files-b1</p>
+</div>
+<div class="section" id="load-graph-functions">
+<h2>Load Graph functions<a class="headerlink" href="#load-graph-functions"
title="Permalink to this headline">¶</a></h2>
+<p>Following are the details about the functions to create vertices and edges
from the file.</p>
+<p>function <code class="docutils literal notranslate"><span
class="pre">load_labels_from_file</span></code> is used to load vertices from
the CSV files.</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span
class="n">load_labels_from_file</span><span class="p">(</span><span
class="s1">'<graph name>'</span><span class="p">,</span>
+ <span class="s1">'<label
name>'</span><span class="p">,</span>
+ <span class="s1">'<file path>'</span><span
class="p">)</span>
+</pre></div>
+</div>
+<p>By adding the fourth parameter user can exclude the id field. *** Use this
when there is no id field in the file***</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span
class="n">load_labels_from_file</span><span class="p">(</span><span
class="s1">'<graph name>'</span><span class="p">,</span>
+ <span class="s1">'<label
name>'</span><span class="p">,</span>
+ <span class="s1">'<file path>'</span><span
class="p">,</span>
+ <span class="k">false</span><span class="p">)</span>
+</pre></div>
+</div>
+<p>Function <code class="docutils literal notranslate"><span
class="pre">load_edges_from_file</span></code> can be used to load properties
from the CSV file. Please see the file structure in the following.</p>
+<p>Note: make sure that ids in the edge file are identical to ones that are in
vertices files.</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span
class="n">oad_edges_from_file</span><span class="p">(</span><span
class="s1">'<graph name>'</span><span class="p">,</span>
+ <span class="s1">'<label name>'</span><span
class="p">,</span>
+ <span class="s1">'<file path>'</span><span
class="p">);</span>
+</pre></div>
+</div>
+</div>
+<div class="section" id="explanation-about-the-csv-format">
+<h2>Explanation about the CSV format<a class="headerlink"
href="#explanation-about-the-csv-format" title="Permalink to this
headline">¶</a></h2>
+<p>Following is the explanation about the structure for CSV files for vertices
and edges.</p>
+<ul class="simple">
+<li><p>A CSV file for nodes shall be formatted aw following;</p></li>
+</ul>
+<table class="colwidths-auto docutils align-default">
+<thead>
+<tr class="row-odd"><th class="head"><p>field name</p></th>
+<th class="head"><p>Field description</p></th>
+</tr>
+</thead>
+<tbody>
+<tr class="row-even"><td><p>id</p></td>
+<td><p>it shall be the first column of the file and all values shall be a
positive integer. This is an optional field when <code class="docutils literal
notranslate"><span class="pre">id_field_exists</span></code> is
<em><strong>false</strong></em>. However, it should be present when <code
class="docutils literal notranslate"><span
class="pre">id_field_exists</span></code> is <em><strong>not</strong></em> set
to false.</p></td>
+</tr>
+<tr class="row-odd"><td><p>Properties</p></td>
+<td><p>all other columns contains the properties for the nodes. Header row
shall contain the name of property</p></td>
+</tr>
+</tbody>
+</table>
+<ul class="simple">
+<li><p>Similarly, a CSV file for edges shall be formatted as follows</p></li>
+</ul>
+<table class="colwidths-auto docutils align-default">
+<thead>
+<tr class="row-odd"><th class="head"><p>field name</p></th>
+<th class="head"><p>Field description</p></th>
+</tr>
+</thead>
+<tbody>
+<tr class="row-even"><td><p>start_id</p></td>
+<td><p>node id of the node from where the edge is stated. This id shall be
present in nodes.csv file.</p></td>
+</tr>
+<tr class="row-odd"><td><p>start_vertex_type</p></td>
+<td><p>class of the node</p></td>
+</tr>
+<tr class="row-even"><td><p>end_id</p></td>
+<td><p>end id of the node at which the edge shall be terminated</p></td>
+</tr>
+<tr class="row-odd"><td><p>end_vertex_type</p></td>
+<td><p>Class of the node</p></td>
+</tr>
+<tr class="row-even"><td><p>properties</p></td>
+<td><p>properties of the edge. the header shall contain the property
name</p></td>
+</tr>
+</tbody>
+</table>
+<p>example files can be viewed at <code class="docutils literal
notranslate"><span class="pre">regress/age_load/data</span></code></p>
+</div>
+<div class="section" id="example-sql-script">
+<h2>Example SQL script<a class="headerlink" href="#example-sql-script"
title="Permalink to this headline">¶</a></h2>
+<ul class="simple">
+<li><p>Load and create graph</p></li>
+</ul>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">LOAD</span> <span
class="s1">'age'</span><span class="p">;</span>
+
+<span class="k">SET</span> <span class="n">search_path</span> <span
class="k">TO</span> <span class="n">ag_catalog</span><span class="p">;</span>
+<span class="k">SELECT</span> <span class="n">create_graph</span><span
class="p">(</span><span class="s1">'agload_test_graph'</span><span
class="p">);</span>
+</pre></div>
+</div>
+<ul class="simple">
+<li><p>Create label <code class="docutils literal notranslate"><span
class="pre">country</span></code> and load vertices from csv file. *** Note
this CSV file has id field ***</p></li>
+</ul>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span> <span
class="n">create_vlabel</span><span class="p">(</span><span
class="s1">'agload_test_graph'</span><span class="p">,</span><span
class="s1">'Country'</span><span class="p">);</span>
+<span class="k">SELECT</span> <span
class="n">load_labels_from_file</span><span class="p">(</span><span
class="s1">'agload_test_graph'</span><span class="p">,</span>
+ <span class="s1">'Country'</span><span
class="p">,</span>
+ <span
class="s1">'age_load/countries.csv'</span><span class="p">);</span>
+</pre></div>
+</div>
+<ul class="simple">
+<li><p>Create label <code class="docutils literal notranslate"><span
class="pre">City</span></code> and load vertices from csv file. *** Note this
CSV file has id field ***</p></li>
+</ul>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span> <span
class="n">create_vlabel</span><span class="p">(</span><span
class="s1">'agload_test_graph'</span><span class="p">,</span><span
class="s1">'City'</span><span class="p">);</span>
+<span class="k">SELECT</span> <span
class="n">load_labels_from_file</span><span class="p">(</span><span
class="s1">'agload_test_graph'</span><span class="p">,</span>
+ <span class="s1">'City'</span><span
class="p">,</span>
+ <span
class="s1">'age_load/cities.csv'</span><span class="p">);</span>
+</pre></div>
+</div>
+<ul class="simple">
+<li><p>Create label <code class="docutils literal notranslate"><span
class="pre">has_city</span></code> and load edges from csv file.</p></li>
+</ul>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span> <span
class="n">create_elabel</span><span class="p">(</span><span
class="s1">'agload_test_graph'</span><span class="p">,</span><span
class="s1">'has_city'</span><span class="p">);</span>
+<span class="k">SELECT</span> <span class="n">load_edges_from_file</span><span
class="p">(</span><span class="s1">'agload_test_graph'</span><span
class="p">,</span> <span class="s1">'has_city'</span><span
class="p">,</span>
+ <span class="s1">'age_load/edges.csv'</span><span
class="p">);</span>
+</pre></div>
+</div>
+<ul class="simple">
+<li><p>check if the graph has been loaded properly</p></li>
+</ul>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span>SELECT table_catalog, table_schema,
table_name, table_type
+FROM information_schema.tables
+WHERE table_schema = 'agload_test_graph';
+
+SELECT COUNT(*) FROM agload_test_graph."Country";
+SELECT COUNT(*) FROM agload_test_graph."City";
+SELECT COUNT(*) FROM agload_test_graph."has_city";
+
+SELECT COUNT(*) FROM cypher('agload_test_graph', $$MATCH(n) RETURN
n$$) as (n agtype);
+SELECT COUNT(*) FROM cypher('agload_test_graph', $$MATCH
(a)-[e]->(b) RETURN e$$) as (n agtype);
+</pre></div>
+</div>
+<div class="section" id="creating-vertices-without-id-field-in-the-file">
+<h3>Creating vertices without id field in the file.<a class="headerlink"
href="#creating-vertices-without-id-field-in-the-file" title="Permalink to this
headline">¶</a></h3>
+<ul class="simple">
+<li><p>Create label <code class="docutils literal notranslate"><span
class="pre">country</span></code> and load vertices from csv file. *** Note
this CSV file has no id field ***</p></li>
+</ul>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span> <span
class="n">create_vlabel</span><span class="p">(</span><span
class="s1">'agload_test_graph'</span><span class="p">,</span><span
class="s1">'Country2'</span><span class="p">);</span>
+<span class="k">SELECT</span> <span
class="n">load_labels_from_file</span><span class="p">(</span><span
class="s1">'agload_test_graph'</span><span class="p">,</span>
+ <span class="s1">'Country2'</span><span
class="p">,</span>
+ <span
class="s1">'age_load/countries.csv'</span><span class="p">,</span>
+ <span class="k">false</span><span
class="p">);</span>
+</pre></div>
+</div>
+<ul class="simple">
+<li><p>Create label <code class="docutils literal notranslate"><span
class="pre">City</span></code> and load vertices from csv file. *** Note this
CSV file has id field ***</p></li>
+</ul>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span> <span
class="n">create_vlabel</span><span class="p">(</span><span
class="s1">'agload_test_graph'</span><span class="p">,</span><span
class="s1">'City2'</span><span class="p">);</span>
+<span class="k">SELECT</span> <span
class="n">load_labels_from_file</span><span class="p">(</span><span
class="s1">'agload_test_graph'</span><span class="p">,</span>
+ <span class="s1">'City2'</span><span
class="p">,</span>
+ <span
class="s1">'age_load/cities.csv'</span><span class="p">,</span>
+ <span class="k">false</span><span
class="p">);</span>
+</pre></div>
+</div>
+<ul class="simple">
+<li><p>check if the graph has been loaded properly and perform difference
analysis between ids created automatically and picked from the files.</p></li>
+<li><p>labels <code class="docutils literal notranslate"><span
class="pre">country</span></code> and <code class="docutils literal
notranslate"><span class="pre">city</span></code> were created with id field in
the file</p></li>
+<li><p>labels <code class="docutils literal notranslate"><span
class="pre">country2</span></code> and <code class="docutils literal
notranslate"><span class="pre">city2</span></code> were created with no id
field in the file.</p></li>
+</ul>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span>SELECT COUNT(*) FROM
agload_test_graph."Country2";
+SELECT COUNT(*) FROM agload_test_graph."City2";
+
+SELECT id FROM agload_test_graph."Country" LIMIT 10;
+SELECT id FROM agload_test_graph."Country2" LIMIT 10;
+
+SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country {iso2 :
'BE'})
+ RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype,
"n.name" agtype, "n.iso2" agtype);
+SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country2 {iso2 :
'BE'})
+ RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype,
"n.name" agtype, "n.iso2" agtype);
+
+SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country {iso2 :
'AT'})
+ RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype,
"n.name" agtype, "n.iso2" agtype);
+SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country2 {iso2 :
'AT'})
+ RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype,
"n.name" agtype, "n.iso2" agtype);
+
+SELECT drop_graph('agload_test_graph', true);
+</pre></div>
+</div>
+</div>
+</div>
+</div>
+
+
+ </div>
+
+ </div>
+ <footer>
+ <div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
+ <a href="../clauses/match.html" class="btn btn-neutral float-right"
title="MATCH" accesskey="n" rel="next">Next <span class="fa
fa-arrow-circle-right" aria-hidden="true"></span></a>
+ <a href="aggregation.html" class="btn btn-neutral float-left"
title="Aggregation" accesskey="p" rel="prev"><span class="fa
fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
+ </div>
+
+ <hr/>
+
+ <div role="contentinfo">
+ <p>
+ © Copyright 2021, Apache AGE.
+
+ </p>
+ </div>
+
+
+
+ Built with <a href="https://www.sphinx-doc.org/";>Sphinx</a> using a
+
+ <a href="https://github.com/readthedocs/sphinx_rtd_theme";>theme</a>
+
+ provided by <a href="https://readthedocs.org";>Read the Docs</a>.
+
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+<div class="rst-versions" data-toggle="rst-versions" role="note"
aria-label="versions">
+ <span class="rst-current-version" data-toggle="rst-current-version">
+ <span class="fa fa-book"> Other Versions</span>
+ v: master
+ <span class="fa fa-caret-down"></span>
+ </span>
+ <div class="rst-other-versions">
+ <dl>
+ <dt>Versions</dt>
+ <dd><a href="agload.html">master</a></dd>
+ <dd><a href="../../v0.6.0/index.html">v0.6.0</a></dd>
+ </dl>
+ </div>
+</div>
+
+ <script type="text/javascript">
+ jQuery(function () {
+ SphinxRtdTheme.Navigation.enable(true);
+ });
+ </script>
+
+
+
+
+
+
+</body>
+</html>
\ No newline at end of file
diff --git a/docs/master/intro/comparability.html
b/docs/master/intro/comparability.html
index 1a9663a..aa6ed15 100644
--- a/docs/master/intro/comparability.html
+++ b/docs/master/intro/comparability.html
@@ -117,6 +117,7 @@
</li>
<li class="toctree-l1"><a class="reference internal"
href="operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/intro/cypher.html b/docs/master/intro/cypher.html
index e514890..b95afd1 100644
--- a/docs/master/intro/cypher.html
+++ b/docs/master/intro/cypher.html
@@ -108,6 +108,7 @@
<li class="toctree-l1"><a class="reference internal"
href="comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/intro/graphs.html b/docs/master/intro/graphs.html
index 2cd1939..86a1804 100644
--- a/docs/master/intro/graphs.html
+++ b/docs/master/intro/graphs.html
@@ -114,6 +114,7 @@
<li class="toctree-l1"><a class="reference internal"
href="comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/intro/operators.html b/docs/master/intro/operators.html
index a02be3f..c3581d0 100644
--- a/docs/master/intro/operators.html
+++ b/docs/master/intro/operators.html
@@ -122,6 +122,7 @@
</ul>
</li>
<li class="toctree-l1"><a class="reference internal"
href="aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/intro/overview.html b/docs/master/intro/overview.html
index fa38397..1ae46d4 100644
--- a/docs/master/intro/overview.html
+++ b/docs/master/intro/overview.html
@@ -103,6 +103,7 @@
<li class="toctree-l1"><a class="reference internal"
href="comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/intro/precedence.html
b/docs/master/intro/precedence.html
index 17c0a4b..8a7f92f 100644
--- a/docs/master/intro/precedence.html
+++ b/docs/master/intro/precedence.html
@@ -101,6 +101,7 @@
<li class="toctree-l1"><a class="reference internal"
href="comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/intro/setup.html b/docs/master/intro/setup.html
index 3633653..7f5fc3e 100644
--- a/docs/master/intro/setup.html
+++ b/docs/master/intro/setup.html
@@ -123,6 +123,7 @@
<li class="toctree-l1"><a class="reference internal"
href="comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/intro/types.html b/docs/master/intro/types.html
index d115dbf..8fa310b 100644
--- a/docs/master/intro/types.html
+++ b/docs/master/intro/types.html
@@ -163,6 +163,7 @@
<li class="toctree-l1"><a class="reference internal"
href="comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/objects.inv b/docs/master/objects.inv
index 04fc5a8..783dc6f 100644
Binary files a/docs/master/objects.inv and b/docs/master/objects.inv differ
diff --git a/docs/master/search.html b/docs/master/search.html
index 82897d1..0c4bd12 100644
--- a/docs/master/search.html
+++ b/docs/master/search.html
@@ -104,6 +104,7 @@
<li class="toctree-l1"><a class="reference internal"
href="intro/comparability.html">Comparability, Equality, Orderability and
Equivalence</a></li>
<li class="toctree-l1"><a class="reference internal"
href="intro/operators.html">Operators</a></li>
<li class="toctree-l1"><a class="reference internal"
href="intro/aggregation.html">Aggregation</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="intro/agload.html">Importing graph from files</a></li>
</ul>
<p class="caption" role="heading"><span class="caption-text">Clauses</span></p>
<ul>
diff --git a/docs/master/searchindex.js b/docs/master/searchindex.js
index b7d268a..54a7a8f 100644
--- a/docs/master/searchindex.js
+++ b/docs/master/searchindex.js
@@ -1 +1 @@
-Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","advanced/sql_in_cypher","clauses/create","clauses/delete","clauses/limit","clauses/match","clauses/order_by","clauses/remove","clauses/return","clauses/set","clauses/skip","clauses/with","functions/aggregate_functions","functions/list_functions","functions/logarithmic_functions","functions/numeric_functions","functions/predicate_functions","functions/scalar_funct
[...]
\ No newline at end of file
+Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","advanced/sql_in_cypher","clauses/create","clauses/delete","clauses/limit","clauses/match","clauses/order_by","clauses/remove","clauses/return","clauses/set","clauses/skip","clauses/with","functions/aggregate_functions","functions/list_functions","functions/logarithmic_functions","functions/numeric_functions","functions/predicate_functions","functions/scalar_funct
[...]
\ No newline at end of file
diff --git a/docs/v0.6.0/.buildinfo b/docs/v0.6.0/.buildinfo
index 4328c35..728ca79 100644
--- a/docs/v0.6.0/.buildinfo
+++ b/docs/v0.6.0/.buildinfo
@@ -1,4 +1,4 @@
# Sphinx build info version 1
# This file hashes the configuration used when building these files. When it
is not found, a full rebuild will be done.
-config: b17b939257a22ed49fabffef05a80b63
+config: 89689b09d1825e932605bb113097b506
tags: 645f666f9bcd5a90fca523b33c5a78b7
diff --git a/docs/v0.6.0/.doctrees/advanced/advanced.doctree
b/docs/v0.6.0/.doctrees/advanced/advanced.doctree
index edd1801..1069054 100644
Binary files a/docs/v0.6.0/.doctrees/advanced/advanced.doctree and
b/docs/v0.6.0/.doctrees/advanced/advanced.doctree differ
diff --git a/docs/v0.6.0/.doctrees/advanced/advanced_overview.doctree
b/docs/v0.6.0/.doctrees/advanced/advanced_overview.doctree
index 5252c32..6b5d84f 100644
Binary files a/docs/v0.6.0/.doctrees/advanced/advanced_overview.doctree and
b/docs/v0.6.0/.doctrees/advanced/advanced_overview.doctree differ
diff --git a/docs/v0.6.0/.doctrees/advanced/plpgsql.doctree
b/docs/v0.6.0/.doctrees/advanced/plpgsql.doctree
index 6d8d1f2..5664a4b 100644
Binary files a/docs/v0.6.0/.doctrees/advanced/plpgsql.doctree and
b/docs/v0.6.0/.doctrees/advanced/plpgsql.doctree differ
diff --git a/docs/v0.6.0/.doctrees/advanced/prepared_statements.doctree
b/docs/v0.6.0/.doctrees/advanced/prepared_statements.doctree
index 52b309d..e619de0 100644
Binary files a/docs/v0.6.0/.doctrees/advanced/prepared_statements.doctree and
b/docs/v0.6.0/.doctrees/advanced/prepared_statements.doctree differ
diff --git a/docs/v0.6.0/.doctrees/advanced/sql_in_cypher.doctree
b/docs/v0.6.0/.doctrees/advanced/sql_in_cypher.doctree
index efc03df..f6d74ed 100644
Binary files a/docs/v0.6.0/.doctrees/advanced/sql_in_cypher.doctree and
b/docs/v0.6.0/.doctrees/advanced/sql_in_cypher.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/create.doctree
b/docs/v0.6.0/.doctrees/clauses/create.doctree
index a69e67b..f31cfe5 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/create.doctree and
b/docs/v0.6.0/.doctrees/clauses/create.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/delete.doctree
b/docs/v0.6.0/.doctrees/clauses/delete.doctree
index 100221d..b6f0120 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/delete.doctree and
b/docs/v0.6.0/.doctrees/clauses/delete.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/limit.doctree
b/docs/v0.6.0/.doctrees/clauses/limit.doctree
index 3103010..dadaf86 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/limit.doctree and
b/docs/v0.6.0/.doctrees/clauses/limit.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/match.doctree
b/docs/v0.6.0/.doctrees/clauses/match.doctree
index 2938c98..732271b 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/match.doctree and
b/docs/v0.6.0/.doctrees/clauses/match.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/order_by.doctree
b/docs/v0.6.0/.doctrees/clauses/order_by.doctree
index d3c6cf4..2ce185a 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/order_by.doctree and
b/docs/v0.6.0/.doctrees/clauses/order_by.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/remove.doctree
b/docs/v0.6.0/.doctrees/clauses/remove.doctree
index 9719c02..731c266 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/remove.doctree and
b/docs/v0.6.0/.doctrees/clauses/remove.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/return.doctree
b/docs/v0.6.0/.doctrees/clauses/return.doctree
index e03515a..2e9154e 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/return.doctree and
b/docs/v0.6.0/.doctrees/clauses/return.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/set.doctree
b/docs/v0.6.0/.doctrees/clauses/set.doctree
index 6318d9f..0f0913c 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/set.doctree and
b/docs/v0.6.0/.doctrees/clauses/set.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/skip.doctree
b/docs/v0.6.0/.doctrees/clauses/skip.doctree
index 4f75d88..7079ed0 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/skip.doctree and
b/docs/v0.6.0/.doctrees/clauses/skip.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/with.doctree
b/docs/v0.6.0/.doctrees/clauses/with.doctree
index 68d23e9..3613ff2 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/with.doctree and
b/docs/v0.6.0/.doctrees/clauses/with.doctree differ
diff --git a/docs/v0.6.0/.doctrees/environment.pickle
b/docs/v0.6.0/.doctrees/environment.pickle
index f2a0efc..a7c2839 100644
Binary files a/docs/v0.6.0/.doctrees/environment.pickle and
b/docs/v0.6.0/.doctrees/environment.pickle differ
diff --git a/docs/v0.6.0/.doctrees/functions/aggregate_functions.doctree
b/docs/v0.6.0/.doctrees/functions/aggregate_functions.doctree
index 613e242..e716de4 100644
Binary files a/docs/v0.6.0/.doctrees/functions/aggregate_functions.doctree and
b/docs/v0.6.0/.doctrees/functions/aggregate_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/list_functions.doctree
b/docs/v0.6.0/.doctrees/functions/list_functions.doctree
index dccf2f0..09b723c 100644
Binary files a/docs/v0.6.0/.doctrees/functions/list_functions.doctree and
b/docs/v0.6.0/.doctrees/functions/list_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/logarithmic_functions.doctree
b/docs/v0.6.0/.doctrees/functions/logarithmic_functions.doctree
index 0390027..3a353dd 100644
Binary files a/docs/v0.6.0/.doctrees/functions/logarithmic_functions.doctree
and b/docs/v0.6.0/.doctrees/functions/logarithmic_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/numeric_functions.doctree
b/docs/v0.6.0/.doctrees/functions/numeric_functions.doctree
index bb77587..f19986c 100644
Binary files a/docs/v0.6.0/.doctrees/functions/numeric_functions.doctree and
b/docs/v0.6.0/.doctrees/functions/numeric_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/predicate_functions.doctree
b/docs/v0.6.0/.doctrees/functions/predicate_functions.doctree
index b6965d9..3f76915 100644
Binary files a/docs/v0.6.0/.doctrees/functions/predicate_functions.doctree and
b/docs/v0.6.0/.doctrees/functions/predicate_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/scalar_functions.doctree
b/docs/v0.6.0/.doctrees/functions/scalar_functions.doctree
index a735518..e3c9f3c 100644
Binary files a/docs/v0.6.0/.doctrees/functions/scalar_functions.doctree and
b/docs/v0.6.0/.doctrees/functions/scalar_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/string_functions.doctree
b/docs/v0.6.0/.doctrees/functions/string_functions.doctree
index 96af699..67442cc 100644
Binary files a/docs/v0.6.0/.doctrees/functions/string_functions.doctree and
b/docs/v0.6.0/.doctrees/functions/string_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/trigonometric_functions.doctree
b/docs/v0.6.0/.doctrees/functions/trigonometric_functions.doctree
index 984d373..e5cb5b8 100644
Binary files a/docs/v0.6.0/.doctrees/functions/trigonometric_functions.doctree
and b/docs/v0.6.0/.doctrees/functions/trigonometric_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/user_functions.doctree
b/docs/v0.6.0/.doctrees/functions/user_functions.doctree
index 0af73c9..d5c5c0e 100644
Binary files a/docs/v0.6.0/.doctrees/functions/user_functions.doctree and
b/docs/v0.6.0/.doctrees/functions/user_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/index.doctree
b/docs/v0.6.0/.doctrees/index.doctree
index 79d0d07..74106b9 100644
Binary files a/docs/v0.6.0/.doctrees/index.doctree and
b/docs/v0.6.0/.doctrees/index.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/aggregation.doctree
b/docs/v0.6.0/.doctrees/intro/aggregation.doctree
index 1f6f0d4..2888d04 100644
Binary files a/docs/v0.6.0/.doctrees/intro/aggregation.doctree and
b/docs/v0.6.0/.doctrees/intro/aggregation.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/comparability.doctree
b/docs/v0.6.0/.doctrees/intro/comparability.doctree
index cfadf62..7ad8e8a 100644
Binary files a/docs/v0.6.0/.doctrees/intro/comparability.doctree and
b/docs/v0.6.0/.doctrees/intro/comparability.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/cypher.doctree
b/docs/v0.6.0/.doctrees/intro/cypher.doctree
index 40facc5..9348926 100644
Binary files a/docs/v0.6.0/.doctrees/intro/cypher.doctree and
b/docs/v0.6.0/.doctrees/intro/cypher.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/graphs.doctree
b/docs/v0.6.0/.doctrees/intro/graphs.doctree
index 37e2f7c..9d76a46 100644
Binary files a/docs/v0.6.0/.doctrees/intro/graphs.doctree and
b/docs/v0.6.0/.doctrees/intro/graphs.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/operators.doctree
b/docs/v0.6.0/.doctrees/intro/operators.doctree
index 45ef11d..6667c75 100644
Binary files a/docs/v0.6.0/.doctrees/intro/operators.doctree and
b/docs/v0.6.0/.doctrees/intro/operators.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/overview.doctree
b/docs/v0.6.0/.doctrees/intro/overview.doctree
index f8e8835..ea15c26 100644
Binary files a/docs/v0.6.0/.doctrees/intro/overview.doctree and
b/docs/v0.6.0/.doctrees/intro/overview.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/precedence.doctree
b/docs/v0.6.0/.doctrees/intro/precedence.doctree
index 15a3c10..204562b 100644
Binary files a/docs/v0.6.0/.doctrees/intro/precedence.doctree and
b/docs/v0.6.0/.doctrees/intro/precedence.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/setup.doctree
b/docs/v0.6.0/.doctrees/intro/setup.doctree
index f061c58..169fff4 100644
Binary files a/docs/v0.6.0/.doctrees/intro/setup.doctree and
b/docs/v0.6.0/.doctrees/intro/setup.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/types.doctree
b/docs/v0.6.0/.doctrees/intro/types.doctree
index 5cd5bdd..08c2f54 100644
Binary files a/docs/v0.6.0/.doctrees/intro/types.doctree and
b/docs/v0.6.0/.doctrees/intro/types.doctree differ
