Unable to create material view

When  I use any functions over the columns in select statement,

then mv is not creating.


eg: select name,id from schema.emp;              // no issue with these

     select upper(name),substring(id,1,2) from schema.emp  // mv is not creating


  Please let me know the solution for this..

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • Status Answered
  • 8 mths agoLast active
  • 2Replies
  • 33Views
  • 2 Following