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

[#1]

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

[#2 · Accepted solution]

@Hemalatha Panneerselvam is this what you looking for

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