question Re: I have a column which has tweet data some of it contains more than 3 http.(url).i have to count the rows which has more than 3 https.how to write query in hive in Archives of Support Questions (Read Only)

I have a column which has tweet data some of it contains more than 3 http.(url).i have to count the rows which has more than 3 https.how to write query in hive

hemapanneer — Mon, 06 Jun 2016 20:01:00 GMT

i used the below query to sort out the no of url s in the column ,

select count(col.name) from table name where colname like %http%;

do any one could help me to solve the above scenario

rajkumar_singh — Mon, 06 Jun 2016 21:40:44 GMT

@Hemalatha Panneerselvam is this what you looking for

SELECT count(col_name) FROM table where col_name like '%http%' having count(col_name) >=3