Kevin Scott • over 4 years ago
Big SQL queries extremely slow
Are Big SQL queries slow / unresponsive for anyone else? I've been trying to run the following query:
create hadoop table if not exists watsonblogs (country varchar(2),FeedInfo varchar(300), countryLang varchar(25),published varchar(25), subject varchar(300), tags varchar(100), type varchar(20), url varchar(100)) row format delimited fields terminated by '\t'
Sometimes it takes 2 seconds, sometimes it takes 120 seconds, sometimes it never finishes (no response in the web console). This is from the web URL as well as locally via jdbc.
Comments are closed.