<div dir="ltr">Hmm, i'll go back and check again, but I saw similar when I was testing with Spark a few months ago as well, unless you did a CREATE TABLE and store the stuff in the Hive Metastore, at which point suddenly the same schema started working.<div><br></div><div>Thanks for the clarification anyway Julian.</div><div><br></div><div>Tom</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 27 October 2015 at 23:53, Julian Hyde <span dir="ltr"><<a href="mailto:julianhyde@gmail.com" target="_blank">julianhyde@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I don’t recall what the code does, but it was definitely my intention when I was designing PhysicalSchema that a schema designer could provide enough metadata that you could validate a schema “disconnected”. (I don’t mean literally disconnected, but relying on the metadata in the schema file.) That would include explicit lists of the columns in each table, and the types of those columns.<br>
<br>
And if the actual types in the JDBC source don’t match, presumably there would be a way to reconcile. E.g. ignore what the JDBC source says and apply casts everywhere.<br>
<br>
In other words, what you’re asking for is reasonable.<br>
<br>
Julian<br>
<div><div class="h5"><br>
<br>
> On Oct 27, 2015, at 3:26 AM, Tom Barber <<a href="mailto:tom@analytical-labs.com">tom@analytical-labs.com</a>> wrote:<br>
><br>
> Hello folks<br>
><br>
> Here's a question for you. I've been playing with some NOSQL stuff recently and I'm interested in sitting Mondrian over a few different tools, Drill for example would be great.<br>
><br>
> One problem though seems to be that Mondrian 4 reads the database metadata and doesn't just trust the developer when it comes to defining the schema. But in drill for example unless you store your table in Hive, show tables and metadata lookup doesn't exist because whilst the table exists.. it doesn't, but of course select x,y,z from tablex does work.<br>
><br>
> So..... in Mondrian 4, is there currently any way of bypassing the schema validation? Or do I need to put some effort into allowing that?<br>
><br>
> Thanks<br>
><br>
> Tom<br>
</div></div>> _______________________________________________<br>
> Mondrian mailing list<br>
> <a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</blockquote></div><br></div>