title: Workaround for non equal hive queries
body: <p>I try to rewrite follow query on hive</p>
  
  <pre><code>select 
      TFCT_CHARGE.SUBS_KEY, 
      TFCT_CHARGE.PRODUCT_KEY, 
      TFCT_CHARGE.CHARGE_NVAL, 
      TFCT_CHARGE.B_SUBS_KEY, 
      TFCT_CHARGE.DELETE_DT, 
      HFCT_SUBS_SEGMENT.SEGMENT_KEY, 
      TFCT_CHARGE.EVENT_DT, 
      TFCT_CHARGE.DWH_SRC_TABLE_KEY
    from
  TFCT_CHARGE LEFT OUTER JOIN HFCT_SUBS_SEGMENT
  ON (
  TFCT_CHARGE.B_SUBS_KEY = HFCT_SUBS_SEGMENT.SUBS_KEY and
  TFCT_CHARGE.EVENT_DT &gt;= HFCT_SUBS_SEGMENT.EFF_DT    and
  TFCT_CHARGE.EVENT_DT &lt; HFCT_SUBS_SEGMENT.EXP_DT     and
  HFCT_SUBS_SEGMENT.SEGMENT_TYPE_KEY = 1)
  </code></pre>
  
  <p>But there are non-equal query.
  Could anybody hint me some workaround?
  Tnx!</p>