Neo4j Cypher problems using Memgraph

[Geoffrey Cleaves <gc...@gmail.com>]

Hello. Apache Hop seems to be interpreting some INFO level hints suggested
by Memgraph as errors.

This is the message in Hop's logs:

2024/02/17 20:08:57 - step.0 - ERROR: INFO : Sequential scan will be used
on symbol `s` although there is a filter on labels :Actor, :Seller and
properties id. Consider creating a label-property index.

The suggestion of creating an index is not an error. Is there a way to tell
Hop to stop treating the output as an error? Alternatively (I know this is
not a Hop question), does anybody know how to tell Memgraph to stop
sending this output?

Thanks for your help,

Geoff

Re: Neo4j Cypher problems using Memgraph

[Bart Maertens <ba...@know.bi>]

and the link to the ticket:
[1] https://github.com/apache/hop/issues/3032


On Sun, Feb 18, 2024 at 9:23 AM Bart Maertens <ba...@know.bi> wrote:

> Hi Geoff,
>
> We have an open ticket [1] to handle cypher dialetcs or different graph
> query languages like we do for relational databases.
> When that ticket is implemented, we'll be able to handle these deviations
> from the Neo4j cypher or different cypher relatively quickly.
> Until then, there's not a lot we can do about differences from the Neo4j 4
> cypher...
>
> Regards,
> Bart
>
>
> On Sat, Feb 17, 2024 at 8:14 PM Geoffrey Cleaves <gc...@gmail.com>
> wrote:
>
>> Hello. Apache Hop seems to be interpreting some INFO level hints
>> suggested by Memgraph as errors.
>>
>> This is the message in Hop's logs:
>>
>> 2024/02/17 20:08:57 - step.0 - ERROR: INFO : Sequential scan will be used
>> on symbol `s` although there is a filter on labels :Actor, :Seller and
>> properties id. Consider creating a label-property index.
>>
>> The suggestion of creating an index is not an error. Is there a way to
>> tell Hop to stop treating the output as an error? Alternatively (I know
>> this is not a Hop question), does anybody know how to tell Memgraph to stop
>> sending this output?
>>
>> Thanks for your help,
>>
>> Geoff
>>
>

Re: Neo4j Cypher problems using Memgraph

[Bart Maertens <ba...@know.bi>]

Hi Geoff,

We have an open ticket [1] to handle cypher dialetcs or different graph
query languages like we do for relational databases.
When that ticket is implemented, we'll be able to handle these deviations
from the Neo4j cypher or different cypher relatively quickly.
Until then, there's not a lot we can do about differences from the Neo4j 4
cypher...

Regards,
Bart


On Sat, Feb 17, 2024 at 8:14 PM Geoffrey Cleaves <gc...@gmail.com> wrote:

> Hello. Apache Hop seems to be interpreting some INFO level hints suggested
> by Memgraph as errors.
>
> This is the message in Hop's logs:
>
> 2024/02/17 20:08:57 - step.0 - ERROR: INFO : Sequential scan will be used
> on symbol `s` although there is a filter on labels :Actor, :Seller and
> properties id. Consider creating a label-property index.
>
> The suggestion of creating an index is not an error. Is there a way to
> tell Hop to stop treating the output as an error? Alternatively (I know
> this is not a Hop question), does anybody know how to tell Memgraph to stop
> sending this output?
>
> Thanks for your help,
>
> Geoff
>