Analyze tomcat logs,GUI method seems to have more step than rest client .but rest client get a 500 status.
What's the reason? thinks. This is tomcat log: (Kylin GUI load table Log,sucess.) 192.168.224.4 - - [14/Aug/2017:16:26:25 +0800] "GET /kylin/api/tables?ext=true&project=api HTTP/1.1" 200 2 192.168.224.4 - - [14/Aug/2017:16:26:25 +0800] "GET /kylin/api/cubes?limit=15&offset=0&projectName=api HTTP/1.1" 200 2 192.168.224.4 - - [14/Aug/2017:16:26:28 +0800] "GET /kylin/api/tables/hive HTTP/1.1" 200 110 192.168.224.4 - - [14/Aug/2017:16:26:33 +0800] "GET /kylin/api/tables/hive/metric HTTP/1.1" 200 91 127.0.0.1 - - [14/Aug/2017:16:26:43 +0800] "PUT /kylin/api/cache/table_ext/METRIC.FACT1/update HTTP/1.1" 500 8766 192.168.224.4 - - [14/Aug/2017:16:26:43 +0800] "POST /kylin/api/tables/metric.fact1,/api HTTP/1.1" 200 55 127.0.0.1 - - [14/Aug/2017:16:26:43 +0800] "PUT /kylin/api/cache/table/METRIC.FACT1/update HTTP/1.1" 500 8759 127.0.0.1 - - [14/Aug/2017:16:26:43 +0800] "PUT /kylin/api/cache/project/api/update HTTP/1.1" 200 - 127.0.0.1 - - [14/Aug/2017:16:26:43 +0800] "PUT /kylin/api/cache/table_ext/METRIC.FACT1/update HTTP/1.1" 500 8766 192.168.224.4 - - [14/Aug/2017:16:26:43 +0800] "GET /kylin/api/tables?ext=true&project=api HTTP/1.1" 200 665 127.0.0.1 - - [14/Aug/2017:16:27:32 +0800] "PUT /kylin/api/cache/table_ext/METRIC.FACT1/update HTTP/1.1" 500 8766 (rest load table log,failed) 192.168.224.4 - - [14/Aug/2017:16:27:56 +0800] "POST /kylin/api/tables/metric.fact2,/api HTTP/1.1" 500 148 apache_...@163.com From: ShaoFeng Shi Date: 2017-08-14 13:33 To: dev Subject: Re: Re: kylin load hive table rest is error Kylin Web GUI calls the same REST API; So if Kylin GUI works, you need check your script. You can open the debug mode of browser to see the detail HTTP request header/body, and then use the same in your script. 2017-08-14 11:36 GMT+08:00 apache_...@163.com <apache_...@163.com>: > Yes. > > metric.date_dim is table name in hive > > load is kylin project. > > Executing it in two environments have same error. > > Kylin version:2.0 > > red part is tomcat log: > xx.xx.xx.xx - - [14/Aug/2017:11:37:58 +0800] "GET > /kylin/api/cubes/validEncodings > HTTP/1.1" 200 98 > xx.xx.xx.xx - - [14/Aug/2017:11:39:25 +0800] "POST > /kylin/api/tables/metric.date_dim/load HTTP/1.1" 500 9919 > > > > apache_...@163.com > > From: Billy Liu > Date: 2017-08-13 23:35 > To: dev > Subject: Re: Re: kylin load hive table rest is error > 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 史少锋 > > > -- Best regards, Shaofeng Shi 史少锋