{"image_url":null,"url":"https://htn20190109.hatenablog.com/entry/2023/03/25/223449","published":"2023-03-25 22:34:49","height":"190","blog_title":"HTN20190109\u306e\u65e5\u8a18","width":"100%","author_name":"HTN20190109","version":"1.0","provider_url":"https://hatena.blog","type":"rich","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2023%2F03%2F25%2F223449\" title=\"{Denodo}\u57fa\u672c\u30d3\u30e5\u30fc\u4f5c\u6210SQL\u306e\u751f\u6210 - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"{Denodo}\u57fa\u672c\u30d3\u30e5\u30fc\u4f5c\u6210SQL\u306e\u751f\u6210","blog_url":"https://htn20190109.hatenablog.com/","description":"\u8907\u6570\u306eSQL\u3092\u6d41\u3059\u3068\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u306a\u3044VQL\u30b7\u30a7\u30eb\u304b\u3089\u30af\u30ea\u30c3\u30d7\u30dc\u30fc\u30c9\u30b3\u30d4\u30fc\u6642\u306b\u30d8\u30c3\u30c0\u30fc\u304c\u542b\u307e\u308c\u308b\u306e\u3067\u9664\u304f -- 1. MySQL\u306e\u5834\u5408 -- step 1 \u57fa\u672c\u30d3\u30e5\u30fc\u4f5c\u6210SQL\u4f5c\u6210SQL\u306e\u751f\u6210 select 'select creation_vql from GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW () where data_source_name = ''ds01'' and catalog_name =''test'' and table_name = '''|| table_name||''' and base_view_name = ''b_'||t\u2026","author_url":"https://blog.hatena.ne.jp/HTN20190109/","categories":["Denodo"]}