Back to all discussions

  •   over 8 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.

  • 3 comments

  •   •   over 8 years ago

    Now I can't even access the console, it just hangs. Here's a screen capture from Firefox:

    https://www.dropbox.com/s/w39blij3nlgtv84/unresponsive%20infosphere.mov?dl=0

    Chrome also fails to load (it asks to kill the page because it's unresponsive). Is there a status page or something like that?

  •   •   over 8 years ago

    can you please try restarting console and check if that helps?
    Path: Bluemix Dashboard => Analytics for hadop service => Select "restart" from dropdown menu next to "Launch"

  •   •   over 8 years ago

    That fixed it, thanks for your help ns123456. I'll do that in the future whenever things slow down.

Comments are closed.