Hive Create View as select problem

[#1]

Hi !

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 :

create table as select

create view as select

Please help if you have any suggestions.

[#2]

Hi @Algrach ,

Could you try this and tell me if it works ?

create view if not exists tdv.test_rus as select * from tdv.test_t_rus where c1 = '<the value>';

Best,

Helmi KHALIFA

[#3]

@helmi_khalifa , Hi !

This statement works, but the result is the same  

[#4]

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 ?

Best,

Helmi 

[#5]

a problem with non-English characters ...

Could you try to insert this word : "ИТОГО" into your test table and use it in create view statement ?

Thank's   

[#6]

Could you try on another table?

Looks like you have an encoding problem with these caracteres.

Best,

Helmi KHALIFA

[#7]

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.