Forum Discussion

ddangler's avatar
ddangler
New Contributor III
9 years ago

Facing error when inner joining two document streams

I am trying to do a simple inner join between two document stream but facing the below error :

I did select the option as Unsorted but still it fails with reason Not Ascending order

6 Replies

  • dwhansen-cbg's avatar
    dwhansen-cbg
    Contributor
    6 years ago

    Changing the ORDER BY to Unsorted or adding Sort Snap before the Join fixed the issue.

    • dwhansen-cbg's avatar
      dwhansen-cbg
      Contributor
      6 years ago

      I’m having this issue but there is no answer here. I have my sorted streams set to Ascending and am still having the issue. Can someone please help?

      • Ksivagurunathan's avatar
        Ksivagurunathan
        Contributor
        6 years ago

        try to convert number input stream to string before the join snap using a mapper, sort the both the input and then use the join. it should resolve the issue.