why am i getting following error while creating incremental mv

my code is woking fine with normal python code but when am performing incremental load am getting the following error.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Pls increase the core and memory try the same.

  • This is a generic error and it will be hard to understand the error , I think it is some sql syntax issue. What I suggest is to run the sql from DbVisualizer first and check, so download DbVisualizer , then create a new postgres connection to the incorta server where you add the server host, port as 5442, database as the tenant name with the login/password as that of admin. Then test the above spark sql , make sure you add the schema name to the table name , for eg select s1.FIRST_NAME from smith.Employees s1  ; 

Like Follow
  • 2 yrs agoLast active
  • 2Replies
  • 76Views
  • 3 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.