2 Replies Latest reply on Apr 26, 2010 7:06 PM by 24743

    Views on SEM_MATCH query with filter

    24743
    24743 Apr 26, 2010 2:39 PM
      Hi

      When creating a "normal" view upon a SEM_MATCH query with filter you have to select both columns in the filter.

      With this: "filter => 'syn1 <> syn2" in the SEM_MATCH query I get "ORA-00904: "IS_SYN_FOR": invalid identifier" when selecting from the "normal" view - unless I select both "syn1" and "syn2"

      Select COUNT (*) gives the same error.

      Select * is OK.

      Regards - Christian
      • 1452 Views
      • Tags:
        • 1. Re: Views on SEM_MATCH query with filter
          Matperry-Oracle
          Matperry-Oracle Apr 26, 2010 2:49 PM (in response to 24743)
          Hi,

          I have having a bit of trouble understanding your problem. Could you please post the entire SQL statement that is giving the problem. Also, is there a reason you are using the SEM_MATCH filter argument rather than the SPARQL syntax FILTER support inside the SEM_MATCH graph pattern?

          Thanks,
          Matt
          • 2. Re: Views on SEM_MATCH query with filter
            24743
            24743 Apr 26, 2010 7:06 PM (in response to 24743)
            Hi Matt

            Yes it's a little hard to read - should have been "filter => 'syn1 <> syn2" (which is a SPARQL filter).

            I think the error comes from that you must specify both syn1 and syn2 in the select line; i.e. with the filter above you can't say:

            select syn1 from FROM TABLE (SEM_MATCH (...

            Regards - Christian