tag:blogger.com,1999:blog-5672165237896126100.post3411542878260572546..comments2022-03-27T08:59:33.430-07:00Comments on Julian Hyde on Streaming Data, Open Source OLAP. And stuff.: Table macrosJulian Hydehttp://www.blogger.com/profile/17816795169191026372noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5672165237896126100.post-30403161524201660472021-05-31T14:39:58.917-07:002021-05-31T14:39:58.917-07:00Hi Julian.
Thank you very much for rendering Mondr...Hi Julian.<br />Thank you very much for rendering Mondrian free!<br />Much appreciated.<br />Juanhttps://www.blogger.com/profile/08572977215403025890noreply@blogger.comtag:blogger.com,1999:blog-5672165237896126100.post-73941563675022511062015-02-05T04:14:08.679-08:002015-02-05T04:14:08.679-08:00sorry, it was a typo - in my test case it is singl...sorry, it was a typo - in my test case it is single-quote. Vladimir Dolzhenkohttps://www.blogger.com/profile/09353866985268525403noreply@blogger.comtag:blogger.com,1999:blog-5672165237896126100.post-39626164781956791852015-02-04T08:19:24.090-08:002015-02-04T08:19:24.090-08:00It is reasonable to want to pass in any constant e...It is reasonable to want to pass in any constant expression, but Calcite does not currently support it. Please log a jira case.<br /><br />In your example you'd have to replace double-quoted string with single-quoted strings. Double-quoted strings are identifiers (e.g. column names) and are not constant.Julian Hydehttps://www.blogger.com/profile/17816795169191026372noreply@blogger.comtag:blogger.com,1999:blog-5672165237896126100.post-19499911398887066102015-02-04T03:06:47.552-08:002015-02-04T03:06:47.552-08:00Another question:
Is it possible to pass through ...Another question:<br /><br />Is it possible to pass through a Map value like<br /><br />TABLE(MYMACRO(MAP["key", "value"])) <br /><br />finally it goes to SqlUserDefinedTableMacro.convertArguments but it expects to get just a literal (not a collection or map) and fails.<br /><br />I got an advice from Vladimir Sitnokov to use a TableFunction - but that's just another way.Vladimir Dolzhenkohttps://www.blogger.com/profile/09353866985268525403noreply@blogger.comtag:blogger.com,1999:blog-5672165237896126100.post-81545149144707575172015-02-03T11:41:13.226-08:002015-02-03T11:41:13.226-08:00It seems reasonable for it to be other sub-types o...It seems reasonable for it to be other sub-types of Table. I'm not sure why the return type was changed (although Vladimir probably had a good reason). I've logged https://issues.apache.org/jira/browse/CALCITE-584 to track this.<br /><br />Yes, we need more documentation. A good place would be https://github.com/apache/incubator-calcite/blob/master/doc/TUTORIAL.md.Julian Hydehttps://www.blogger.com/profile/17816795169191026372noreply@blogger.comtag:blogger.com,1999:blog-5672165237896126100.post-31425542231077472332015-02-03T02:05:52.189-08:002015-02-03T02:05:52.189-08:00The example seems a bit outdated:
eval method has ...The example seems a bit outdated:<br /><b>eval</b> method has to return a <b>TranslatableTable</b> instance to be a proper macro function. <br /><br />There is a lack of documentation and examples - the most valuable is test cases. Is there any plans to cover the common cases in a wiki or document it somehow ?Vladimir Dolzhenkohttps://www.blogger.com/profile/09353866985268525403noreply@blogger.com