[Mondrian] Error running tests against foodmart db
Julian Hyde
jhyde at pentaho.com
Wed Jul 31 15:51:35 EDT 2013
On Jul 31, 2013, at 12:40 PM, "Chacko, Rachel (Truven Health)" <rachel.chacko at truvenhealth.com<mailto:rachel.chacko at truvenhealth.com>> wrote:
Thanks for the reply! I can connect to the db using Squirrel(SQL tool) and I do see the table ‘time_by_day’, but when I try ‘select * from time_by_day’ I get
Error: Table/View 'TIME_BY_DAY' does not exist.
SQLState: 42X05
ErrorCode: 30000
Still not sure if it is a permissions issue.
It's case-sensitivity. Try
select * from "time_by_day";
Julian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130731/f6d5a625/attachment.html
More information about the Mondrian
mailing list