SELECT col1,col2,col3,col4 FROM spectrum.mytable WHERE col1<>'' AND col2<>'' LIMIT 100;