Geek Answers Handbook

Is it possible to alias or rename fields in YQL?

I make a bunch of YQL queries right away and have a standard way to access fields on the server. Unfortunately, one of the channels uses a different name than the rest for the field, so I assumed that I could use it in YQL.

Sort of:

SELECT title, link, encoded AS description FROM...

But it looks like the YQL parser doesn't like it when I get this error:

Syntax error(s) [line 1:37 expecting field got 'AS']

So, is it possible to use aliases in YQL, as you can in SQL? I have not seen anything in YQL docs or on the web in general.

Occupying another (small) question, is there a specification somewhere for YQL syntax?

+5
source share
2 answers

, YQL. ( @codeulike, "SQL", MySQL .)

, , Open Tables . . YQL Open Tables "".

+1

, YQL SQL ; , SELECT, SQL. , , , .

: http://developer.yahoo.com/yql/guide/select_statement.html... aliasing of fields , .

, YQL Yahoo Pipes, Rename .

0

More articles:


All Articles