kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "apache_dev@163.com" <apache_...@163.com>
Subject Re: Re: kylin load hive table rest is error
Date Mon, 14 Aug 2017 08:33:59 GMT

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_dev@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_dev@163.com <apache_dev@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_dev@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_dev@163.com <apache_dev@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_dev@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 <shaofengshi@apache.org>:
> >
> > > Any message in tomcat/logs/* or logs/kylin.out?
> > >
> > > 2017-08-13 10:21 GMT+08:00 apache_dev@163.com <apache_dev@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_dev@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_dev@163.com <apache_dev@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_dev@163.com
> > >> >
> > >>
> > >>
> > >>
> > >> --
> > >> Best regards,
> > >>
> > >> Shaofeng Shi 史少锋
> > >>
> > >
> > >
> > >
> > > --
> > > Best regards,
> > >
> > > Shaofeng Shi 史少锋
> > >
> > >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
>
 
 
 
-- 
Best regards,
 
Shaofeng Shi 史少锋
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message