cannot define an index of TYPE HASHED on a temporary table

  Explanation:  Temporary tables  only  support  indexes  of  TYPE
  SORTED.   You  attempted  to create an index of TYPE HASHED on a
  temporary table.

  User  Action:   Redefine  the  index  with  TYPE  SORTED  for  a
  temporary table.