Support Questions
Find answers, ask questions, and share your expertise

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

Solved Go to solution
Highlighted

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

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

@Hemalatha Panneerselvam is this what you looking for

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

View solution in original post

1 REPLY 1
Highlighted

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

@Hemalatha Panneerselvam is this what you looking for

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

View solution in original post

Don't have an account?