I have this view: And I wanted to add a new column with the following replication code: but he returns the error: I thought about deleting this table that already exists, but I don’t know if it would be the best way to do it. How can I do it? Answer you can use alter view. Its better because it
Tag: hue
How to get min and max from 7 columns in Hive Hue excluding zeros
I have a table which has 9 columns. Below is the structure of it I need the min and max of these columns for a row excluding zeros. Below is the required table structure If you see the columns min and max, min is minimum of 7 cols (col1 to col7) in a particular row excluding zero and max is
Combining 3 Tables and Finding Average Age in SQL
I need to combine three tables and find the average age after combining the three tables using SQL. The name of the age columns in the three tables are pr16pnk.age, pr16puf.age, and pr16yag.age. I have successfully found the results when the tables are separated, but I am having trouble combining the results. Listed below is the code that I used.
Count distinct with HUE/IMPALA
I have a table in HUE like : I need to count the distinct number of ProductID’s for each ID. Something like this : I’ve tried : What I really need to do is a count(distinct) inside the analytical function. HUE doesn’t let me do this. Is there another way I can count distinct for window of rows? Answer Your
Date is not displaying correct with substr & like query
I am trying to get this out out, but i am experiencing that the substr i am using is incorrect , For an example , all my columns are displaying hdfs://asdasda/asdas/fdsfdsfd/received_files/asdasd_20191231_11122333_123456789_CO.dat some of which has more character so in order for me to get the exact date in the column is inconsistent if i am using subsring some will return