I have following select statement :
I need help with the following :
When I try to create a View using this select statement I'm getting the next result :
So, view is created but result set is empty ...
Also, there is a difference between creating table as select and creating a view using the same select :
Please help if you have any suggestions.
I just tried it and it works for me as you can see in the print screen below:
Are you sure that the table is not empty ?
a problem with non-English characters ...
Could you try to insert this word : "ИТОГО" into your test table and use it in create view statement ?
Could you try on another table?
Looks like you have an encoding problem with these caracteres.
Hive works in UTF-8 by default
Create table as select with this condition works well, but view cannot be created correctly with the same condition.