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.
[email protected]
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 <[email protected]>:
> Any message in tomcat/logs/* or logs/kylin.out?
>
> 2017-08-13 10:21 GMT+08:00 [email protected] <[email protected]>:
>
>> 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
>>
>>
>>
>>
>>
>> [email protected]
>>
>> 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 [email protected] <[email protected]>:
>>
>> >
>> > 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>
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > [email protected]
>> >
>>
>>
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi 史少锋
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>
--
Best regards,
Shaofeng Shi 史少锋
