0

No definition found for Table yahoo.finance.quotes

in yql console i input
select * from yahoo.finance.quotes where symbol in ("YHOO","AAPL","GOOG","MSFT")
the output is
No definition found for Table yahoo.finance.quotes
what's wrong?

by
3 Replies
  • QUOTE (Pengpeng @ Jul 15 2010, 05:43 PM) <{POST_SNAPBACK}>
    in yql console i input
    select * from yahoo.finance.quotes where symbol in ("YHOO","AAPL","GOOG","MSFT")
    the output is
    No definition found for Table yahoo.finance.quotes
    what's wrong?

    CODEBOX
    [url="https://developer.yahoo.com/yql/console/?q=select"]https://developer.yahoo.com/yql/console/?q=select[/url] * from yahoo.finance.quotes where symbol in ("YHOO"%2C"AAPL"%2C"GOOG"%2C"MSFT")&env=store://datatables.org/alltableswithkeys


    Have you enabled community tables? I see that yahoo.finance.quotes is a community table and once enabled it works.
    -balaji
    0
  • i have read the following material , but still don't know how to enable community table, i paste it in the ydl console ,
    https://developer.yahoo.com/yql/console/?q=select * from yahoo.finance.quotes where symbol in ("YHOO"%2C"AAPL"%2C"GOOG"%2C"MSFT")&env=store://datatables.org/alltableswithkeys("YHOO"%2C"AAPL"%2C"GOOG"%2C"MSFT")&env=store://datatables.org/alltableswithkeys

    the output is

    Syntax error(s) [line 1:0 no viable alternative at character '[',line 1:56 no viable alternative at character ']',line 1:62 no viable alternative at character ':']
    https://developer.yahoo.com/yql/console/?q=select * from yahoo.finance.quotes where symbol in ("YHOO"%2C"AAPL"%2C"GOOG"%2C"MSFT")&env=store://datatables.org/alltableswithkeys("YHOO"%2C"AAPL"%2C"GOOG"%2C"MSFT")&env=store://datatables.org/alltableswithkeys

    would you mind to tell me more?
    0
  • http://developer.yahoo.com/yql/guide/yql-o...les-import.html
    the page i have read ,but don't know how to do?
    0

Recent Posts

in YQL