As the document says {tables} and {project} are path parameters, so in your
case, is metric.date_dim the table name, and load the project name?http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load 2017-08-13 22:28 GMT+08:00 apache_...@163.com <apache_...@163.com>: > it can work by Kylin GUI. > > I refer to the API document,but is not work. > > Load Hive Tables > POST /kylin/api/tables/{tables}/{project} > Request Parameters > tables - required string table names you want to load from hive, separated > with comma. > project - required String the project which the tables will be loaded into. > > > > apache_...@163.com > > From: ShaoFeng Shi > Date: 2017-08-13 14:23 > To: dev > Subject: Re: Re: kylin load hive table rest is error > Besides, can you sync the table from Kylin GUI? If GUI doesn't work either, > that should be env problem. Otherwise it would be API usage mistake. > > 2017-08-13 14:22 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>: > > > Any message in tomcat/logs/* or logs/kylin.out? > > > > 2017-08-13 10:21 GMT+08:00 apache_...@163.com <apache_...@163.com>: > > > >> Hi,shaofeng: > >> > >> Kylin2.0 on HDP2.5.3. > >> > >> > >> hive> use metric; > >> OK > >> Time taken: 0.029 seconds > >> hive> show tables; > >> OK > >> buss_info > >> dim > >> dim_curr > >> dim_date > >> dim_dtyp > >> dim_gl_acc > >> dim_org > >> fact1 > >> fact2 > >> Time taken: 0.245 seconds, Fetched: 9 row(s) > >> > >> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_ > >> dim/load > >> return error: > >> Server returned HTTP response code: 500 for URL: > >> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load > >> > >> but no relevant logs in kylin.log > >> > >> > >> > >> > >> > >> apache_...@163.com > >> > >> From: ShaoFeng Shi > >> Date: 2017-08-12 14:59 > >> To: dev > >> Subject: Re: kylin load hive table rest is error > >> Is there any clue in kylin.log? > >> > >> 2017-08-12 9:58 GMT+08:00 apache_...@163.com <apache_...@163.com>: > >> > >> > > >> > Hi, > >> > > >> > Please help confirm a question(bug?),when i run load hive table by > >> > kylin rest interface, it return a error page info > >> > > >> > example: > >> > > >> > post http://xx.xx.xx.xx:7070/kylin/api/metric.date_dim/load > >> > metric.data_dim is hive table, load is kylin project. > >> > > >> > No body. > >> > > >> > > >> > return page info: > >> > > >> > <!-- > >> > * Licensed to the Apache Software Foundation (ASF) under one > >> > * or more contributor license agreements. See the NOTICE file > >> > * distributed with this work for additional information > >> > * regarding copyright ownership. The ASF licenses this file > >> > * to you under the Apache License, Version 2.0 (the > >> > * "License"); you may not use this file except in compliance > >> > * with the License. You may obtain a copy of the License at > >> > * > >> > * http://www.apache.org/licenses/LICENSE-2.0 > >> > * > >> > * Unless required by applicable law or agreed to in writing, software > >> > * distributed under the License is distributed on an "AS IS" BASIS, > >> > * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or > >> implied. > >> > * See the License for the specific language governing permissions and > >> > * limitations under the License. > >> > --> > >> > <!doctype html><html id="ng-app"><head><meta charset="utf-8"><meta > >> > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> > >> > <!-- HTTP 1.1 --> > >> > <meta http-equiv="pragma" content="no-cache"> > >> > <!-- HTTP 1.0 --> > >> > <meta http-equiv="cache-control" content="no-cache"> > >> > <meta name="format-detection" content="telephone=no"> > >> > <base href="/kylin/"> > >> > <link rel="icon" href="image/favicon.ico" type="image/x-icon"> > >> > <link rel="shortcut icon" href="image/favicon.ico" > type="image/x-icon"> > >> > <title>Kylin</title> > >> > <link type="text/css" rel="stylesheet" href="css/styles.min. > >> > 20170503052747.css"> > >> > <!-- This has to be at the top to make it works in IE --> > >> > <!--[if lte IE 8]> > >> > <script> > >> > document.createElement('loading'); > >> > document.createElement('pagination'); > >> > </script> > >> > <![endif]--> > >> > </head> > >> > <body ng-controller="PageCtrl"> > >> > <div class="navbar navbar-default navbar-fixed-top" > >> > ng-include="'partials/header.html'"></div> > >> > <div id="main" class="main-container"> > >> > <div class="main-content"> > >> > <div class="page-content" ng-view></div> > >> > </div> > >> > </div> > >> > <footer class="navbar-fixed-bottom navbar-footer" > >> > ng-include="'partials/footer.html'"></footer> > >> > <script type="text/javascript" src="js/scripts.min. > >> > 20170503052747.js"></script> > >> > <!--template--> > >> > <!-- static template for cube save/update result notification --> > >> > <script type="text/ng-template" id="cubeResultError.html"> > >> > <div class="callout"> > >> > <h4>Error Message</h4> > >> > <p>{{text}}</p> > >> > </div> > >> > <div class="callout callout-danger"> > >> > <h4>Cube Schema</h4> > >> > <pre>{{schema}}</pre> > >> > </div> > >> > </script> > >> > <script type="text/ng-template" id="cubeResultSuccess.html"> > >> > <div class="callout callout-info"> > >> > <p>{{text}}</p> > >> > </div> > >> > </script> > >> > <!--template--> > >> > <!-- static template for cube save/update result notification --> > >> > <script type="text/ng-template" id=" modelResultError.html"> > >> > <div class="callout callout-info"> > >> > <h4>Error Message</h4> > >> > <p>{{text}}</p> > >> > </div> > >> > <div class="callout callout-danger"> > >> > <h4>Model Schema</h4> > >> > <pre>{{schema}}</pre> > >> > </div> > >> > </script> > >> > <script type="text/ng-template" id="modelResultSuccess.html"> > >> > <div class="callout callout-info"> > >> > <p>{{text}}</p> > >> > </div> > >> > </script> > >> > <!-- static template for cube save/update result notification --> > >> > <script type="text/ng-template" id="streamingResultError.html"> > >> > <div class="callout"> > >> > <h4>Error Message</h4> > >> > <p>{{text}}</p> > >> > </div> > >> > <div class="callout callout-danger"> > >> > <h4>Streaming Schema</h4> > >> > <pre>{{streamingSchema}}</pre> > >> > </div> > >> > <div class="callout callout-danger"> > >> > <h4>Kafka Schema</h4> > >> > <pre>{{kfkSchema}}</pre> > >> > </div> > >> > </script> > >> > <script type="text/ng-template" id="streamingResultSuccess.html"> > >> > <div class="callout callout-info"> > >> > <p>{{text}}</p> > >> > </div> > >> > </script> > >> > </body> > >> > </html> > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > apache_...@163.com > >> > > >> > >> > >> > >> -- > >> Best regards, > >> > >> Shaofeng Shi 史少锋 > >> > > > > > > > > -- > > Best regards, > > > > Shaofeng Shi 史少锋 > > > > > > > -- > Best regards, > > Shaofeng Shi 史少锋 >
