use 'https://gist.github.com/swook/2042904/raw/1d3170ecf1b1f33f219cbaa48d056c45cdeb3a98/gistfile1.txt' as remote;
as this is a bottleneck in performance.
You can just copy and paste that table into the YQL Table editor: http://developer.yahoo.com/yql/editor/ after you create a table you'll be presented with 3 keys, execute, select and update. use the store:// as your data source.
so it will look like: use 'store:// ' as remote;
And you'll have YQL host your YQL table and the performance should be much faster.
But still I got the issue which I explained in my previous post. When Fetch Data module is not attach to the Pipe Output module. The results looks goods. But when I attach it to Pipe Output module the data is empty. Even the Fetch Data module.
Right now I attach it to the Pipe Output module. So you can see it is empty.
You are correct that the query was wrong. And nailed it down to "/287 ". But not becuase I forgot it. It's a bug with yahoo.pipe. However I found the issue. I just needed to deattach the String Builder module on the right. That's the only thing I did. Anyway that module was not needed anymore. Since I previously use that String Builder to attach it to the YQL module.
Pipe ID: 93b33e5fd9da3fdd6c18da7abead48ca Works great. URL builder got only the left String Builder attach to it.
Pipe ID: 1adcd1db4d3e3cd1b40b19872c470211 Bug. URL builder got 2 String Builders attach to it. Somehow " /287 " dissepeared in the left String Builder. When the Fetch data module is attach to the Pipe Output module.