In this blog post, let’s learn about the error message “382 Same number of columns must be specified for view and select clause.” in Hydra and the description of the error.
Error Message
382 Same number of columns must be specified for view and select clause.
Error Details
In this VIEW statement, you have listed the names of the columns of the view. However, their number is different from the number of columns in the SELECT statement for the view. Check the punctuation of the two lists, and make sure that you have supplied a name for each item in the select list.