Question 178632 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – Reading csv file produces error in Apache agedb

I am using Apache ageDB and trying to load data from the CSV file, but the reading operation fails after executing the program for some time.

SELECT * FROM create_graph('neurond');
SELECT create_vlabel('neurond','entity');
SELECT * FROM load_labels_from_file('neurond','entity,'./data_dir/entity.csv');

Note: Data path is correct.

This query produces this error:

ERROR: entry_id must be 1 .. 281474976710655

However, the entry_id ranges from 10,000 to 330,000

Tags:

2

Answers


  1. 0

    Try this for loading:

      SELECT * FROM create_graph('neurond');
SELECT create_vlabel('neurond','entity');
SELECT * FROM load_labels_from_file('neurond', 'entity', './data_dir/entity.csv', 'csv', 'header', 'skip', 'entry_id');
    Login or Signup to reply.
  2. 0

    I think the error occurs as result of a missing single quote ' after the word entity the second parameter value of load_labels_from_file function used.

    So try this after fix ,

    SELECT * FROM create_graph('neurond');
SELECT create_vlabel('neurond','entity');
SELECT * FROM load_labels_from_file('neurond','entity','./data_dir/entity.csv');
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search