[GitHub] [age] eyab commented on issue #562: DBMS does not use indexes within where clause
eyab commented on issue #562: URL: https://github.com/apache/age/issues/562#issuecomment-1690899036 @endriux @ed0sh, please let us know how can we contact you. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] jrgemignani commented on issue #1170: AGE make segmentation fault for postgresql 15
jrgemignani commented on issue #1170: URL: https://github.com/apache/age/issues/1170#issuecomment-1690802728 It should not matter which branch you are building off of - the **master** branch is essentially a more current version of the **PG15** branch. Just make sure that your version of PostgreSQL matches the version of AGE. I build either the **master** or **PG15** against PostgreSQL 15.3 Also, a full listing of it being built would be useful. That one error by itself doesn't really say much. Below is my build script, as an example. ``` #! /usr/bin/bash pver=$1 port=$2 build="psql"-$pver-$port-$3 path="~jgemignani/POSTGRESQL/postgresql-$pver/$build/bin" make PG_CONFIG=$path/pg_config clean make PG_CONFIG=$path/pg_config make PG_CONFIG=$path/pg_config install make PG_CONFIG=$path/pg_config installcheck ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] lmeyerov commented on issue #669: Bulk import/export using Arrow ?
lmeyerov commented on issue #669: URL: https://github.com/apache/age/issues/669#issuecomment-1690547667 I think ADBC is the relevant protocol snowflake and others are adopting here -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] lmeyerov commented on issue #669: Bulk import/export using Arrow ?
lmeyerov commented on issue #669: URL: https://github.com/apache/age/issues/669#issuecomment-1690546114 No, we are still curious about bulk ingest/export for use with analytics pipelines, esp subsecond interactive & GPU at 100MB-10GB scales -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 14
Dear Apache Community, We would like to open a discussion for the Apache AGE release 1.4.0 for PostgreSQL 14. To learn more about Apache AGE, please see http://age.apache.org/ Functionalities included and addressed in this release are: * Release Notes for Apache AGE release v1.4.0 for PostgreSQL 14 NOTE: This is an initial release of PG14. There are no upgrade scripts to this release. NOTE: Some of these reference the master branch PR that was either applied to lower versions via a separate PR or merged into a newly created branch. Added license in Python driver README.md (#956) Added the toStringList() function (#1128) Added toBooleanList() (#1165) Added toFloatList() function (#1016) Added toIntegerList() function (#1025) Added regression tests for MATCH clause using labels only (#1019) Added REGTYPEOID to toString function (#1036) Added Dockerfile.dev & move docker-related files to "docker/" (#943) Fixed complex MERGE causes crash (#897) (#961) Fixed docker build files (#1104) Fixed case sensitivity on label usage of reserved keyword (#1040) Fixed issue 1000: Indexes created on WHERE (#1133) Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003) Fixed issue 1033: access operator on vle edge lists (#1037) Fixed issue 1043: ERROR: container must be an array or object (#1046) Fixed issue 1124: Segmentation fault when using specific tables (#1125) Fixed issue 395: ERROR: container is not an agtype array (#1039) Fixed issue 870: regarding orderability and added regression tests (#994) Fixed issue 876: column reference "_age_default_alias_0" is ambiguous (#931) Fixed issue 975: Invalid reuse of variables in CREATE clause (#977) Fixed issue 989: Impossible to create array with > 100 items (#1001) Fixed memory leak issues with age_load (#1142) Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958) Fixed MERGE crashes due to incorrect label type (#957) Fixed MERGE variable reuse (#997) Fixed misspellings in many AGE files (#985) Fixed warning messages in DockerHub builds. (#1075) Modified test_agtypes to view useful testing message (#992) Optimised Antlr4ResultHandler initialization (#1169) Updated CIs to pull correct image based on branch (#1105) Updated files, format, and version information (#1063) Updated README. * The git tag to be discussed and voted on: https://github.com/apache/age/releases/tag/PG14/v1.4.0-rc0 The git commit hash: commit a33b3cf996edaa6d334e30a153ad1ff712c65518 The release files for 1.4.0, can be found at: https://dist.apache.org/repos/dist/dev/age/PG14/1.4.0.rc0/ Signatures used for AGE RCs can be found in this file: https://downloads.apache.org/age/KEYS The fingerprint of key to sign release artifacts: 4293 0603 8E35 AC05 4DBB 4B58 26B6 CD9D CD5B 0045 For information about the contents of this release see: https://github.com/apache/age/releases/tag/PG14/v1.4.0-rc0 Please verify the above links, files, and signatures in addition to sharing your thoughts and feedback and if we can call for a vote. Thank you for your time. John Gemignani
[GitHub] [age] eyab commented on issue #669: Bulk import/export using Arrow ?
eyab commented on issue #669: URL: https://github.com/apache/age/issues/669#issuecomment-1690451379 @lmeyerov do you have any updates on this? Did you find a solution? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] rafsun42 commented on issue #772: Research potential designs to implement IDs for vertices, edges, and labels. Designs that would generally work with existing code and that would permit
rafsun42 commented on issue #772: URL: https://github.com/apache/age/issues/772#issuecomment-1690284325 @nupis-DanielS Hello. Could you please let us know what are your use cases of multiple labels? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] farooquememon385 commented on issue #1127: AGE Integrationn-Project Planning and Requirements Gathering
farooquememon385 commented on issue #1127: URL: https://github.com/apache/age/issues/1127#issuecomment-1690191068 AGE and citus both are extensions to PostgreSQL, we can try to use it by installing both extensions on Postgres cluster -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] Amr-Shams commented on issue #1178: drop_graph('graph_name') fails to Delete Graph
Amr-Shams commented on issue #1178: URL: https://github.com/apache/age/issues/1178#issuecomment-1690139826 When there are multiple graphs with foreign key relationships between them, deleting the "main" graph with the cascade option set to True could cause errors or data integrity issues in the dependent graphs. but as you mentioned it would be better if we set it to "true" and pop up a message in case we found a relation or dependency -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] markgomer commented on issue #1178: drop_graph('graph_name') fails to Delete Graph
markgomer commented on issue #1178: URL: https://github.com/apache/age/issues/1178#issuecomment-1690044732 I actually forgot one argument, so I should be calling `SELECT drop_graph('graph_name', true);`, which works. So now I raise a question: in what cases would setting the `cascade` option to `false` would be useful? Calling the function with `false`, on any graph I tested, raised the same error. Should we change the function so it always considers the `cascade` argument as `true`? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] markgomer opened a new issue, #1178: drop_graph('graph_name') fails to Delete Graph
markgomer opened a new issue, #1178: URL: https://github.com/apache/age/issues/1178 **Describe the bug** `SELECT drop_graph('graph_name')` is not deleting recently created graph. **How are you accessing AGE (Command line, driver, etc.)?** - psql interface, command line. **What is the necessary configuration info needed?** - Fresh install of PostgreSQL 15 and Apache AGE master, on Debian stable-slim Docker image. **What is the command that caused the error?** ```pgsql psql (15.4) Type "help" for help. test=# CREATE EXTENSION age; CREATE EXTENSION test=# LOAD 'age'; SET search_path TO ag_catalog; LOAD SET test=# SELECT * FROM ag_catalog.ag_graph; graphid | name | namespace -+--+--- (0 rows) ``` ``` test=# SELECT create_graph('agload'); NOTICE: graph "agload" has been created create_graph -- (1 row) test=# SELECT drop_graph('agload'); 2023-08-23 10:33:23.574 -03 [28787] ERROR: cannot drop schema agload because other objects depend on it 2023-08-23 10:33:23.574 -03 [28787] DETAIL: table agload._ag_label_vertex depends on schema agload table agload._ag_label_edge depends on schema agload 2023-08-23 10:33:23.574 -03 [28787] HINT: Use DROP ... CASCADE to drop the dependent objects too. 2023-08-23 10:33:23.574 -03 [28787] STATEMENT: SELECT drop_graph('agload'); ERROR: cannot drop schema agload because other objects depend on it DETAIL: table agload._ag_label_vertex depends on schema agload table agload._ag_label_edge depends on schema agload HINT: Use DROP ... CASCADE to drop the dependent objects too. test=# ``` **Expected behavior** After `SELECT drop_graph('graph_name');` the graph should be dropped along with all its vertexes and edges. **Environment (please complete the following information):** - AGE Version: 1.3.0 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] bigplaice closed issue #966: How to export graph data for Giraph analysis?
bigplaice closed issue #966: How to export graph data for Giraph analysis? URL: https://github.com/apache/age/issues/966 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] bigplaice commented on issue #966: How to export graph data for Giraph analysis?
bigplaice commented on issue #966: URL: https://github.com/apache/age/issues/966#issuecomment-1689979819 > @bigplaice Hi Steven, any update if you could get this to work? actually not yet. My project of graph database is freezed before I rush into verification. And probably would not get chance to restart the project. Thanks for help from all of you guys! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] I33Buckler commented on issue #1170: AGE make segmentation fault for postgresql 15
I33Buckler commented on issue #1170: URL: https://github.com/apache/age/issues/1170#issuecomment-1689487739 pg_config is available at /usr/bin/pg_config. No problem resolving the path. I downloaded the PG15 repository with the following 'git clone https://github.com/apache/age.git --branch PG15 --single-branch' Unfortunately still get the segmentation fault when running make. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] vladiksun commented on issue #1000: Index is not used in the WHERE clause
vladiksun commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1689461877 @dehowef thanks for taking a look at this. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org