Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  • Range joins apply only keys whose data types can be compared. 
    • For example, for joins involving keys of Binary data type, you can use Equal to or Not equal to joins.


      Tip: Range joins cannot be applied to Datetime data type values directly. However, you can use the UNIXTIME function to convert the values to numeric Unix time values. Then, you can specify a range join.

  • Any range comparison that includes one or more string columns as keys uses the string comparison greater/less than, not the numerical comparison.


This feature may need to be enabled by a workspace administrator. See Workspace Settings Page.

After range joins have been enabled, you can specify them as part of performing any join operation.