kylin load hive table rest is error

classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

kylin load hive table rest is error

apache_dev@163.com

Hi,

    Please help me confirm a question,when i run load hive table by rest,  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>

 





[hidden email]
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

kylin load hive table rest is error

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>

 





[hidden email]
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: kylin load hive table rest is error

shaofengshi
Is there any clue in kylin.log?

2017-08-12 9:58 GMT+08:00 [hidden email] <[hidden email]>:

>
> 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>
>
>
>
>
>
>
>
> [hidden email]
>



--
Best regards,

Shaofeng Shi 史少锋
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re: kylin load hive table rest is error

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





[hidden email]
 
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 [hidden email] <[hidden email]>:
 

>
> 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>
>
>
>
>
>
>
>
> [hidden email]
>
 
 
 
--
Best regards,
 
Shaofeng Shi 史少锋
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re: kylin load hive table rest is error

shaofengshi
Any message in tomcat/logs/* or logs/kylin.out?

2017-08-13 10:21 GMT+08:00 [hidden email] <[hidden email]>:

> 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
>
>
>
>
>
> [hidden email]
>
> 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 [hidden email] <[hidden email]>:
>
> >
> > 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>
> >
> >
> >
> >
> >
> >
> >
> > [hidden email]
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>



--
Best regards,

Shaofeng Shi 史少锋
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re: kylin load hive table rest is error

shaofengshi
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 <[hidden email]>:

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


--
Best regards,

Shaofeng Shi 史少锋
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re: kylin load hive table rest is error

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.



[hidden email]
 
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 <[hidden email]>:
 

> Any message in tomcat/logs/* or logs/kylin.out?
>
> 2017-08-13 10:21 GMT+08:00 [hidden email] <[hidden email]>:
>
>> 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
>>
>>
>>
>>
>>
>> [hidden email]
>>
>> 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 [hidden email] <[hidden email]>:
>>
>> >
>> > 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>
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > [hidden email]
>> >
>>
>>
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi 史少锋
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>
 
 
--
Best regards,
 
Shaofeng Shi 史少锋
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re: kylin load hive table rest is error

Billy Liu
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 [hidden email] <[hidden email]>:

> 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.
>
>
>
> [hidden email]
>
> 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 <[hidden email]>:
>
> > Any message in tomcat/logs/* or logs/kylin.out?
> >
> > 2017-08-13 10:21 GMT+08:00 [hidden email] <[hidden email]>:
> >
> >> 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
> >>
> >>
> >>
> >>
> >>
> >> [hidden email]
> >>
> >> 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 [hidden email] <[hidden email]>:
> >>
> >> >
> >> > 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>
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > [hidden email]
> >> >
> >>
> >>
> >>
> >> --
> >> Best regards,
> >>
> >> Shaofeng Shi 史少锋
> >>
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
> >
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re: kylin load hive table rest is error

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







[hidden email]
 
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 [hidden email] <[hidden email]>:
 

> 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.
>
>
>
> [hidden email]
>
> 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 <[hidden email]>:
>
> > Any message in tomcat/logs/* or logs/kylin.out?
> >
> > 2017-08-13 10:21 GMT+08:00 [hidden email] <[hidden email]>:
> >
> >> 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
> >>
> >>
> >>
> >>
> >>
> >> [hidden email]
> >>
> >> 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 [hidden email] <[hidden email]>:
> >>
> >> >
> >> > 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>
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > [hidden email]
> >> >
> >>
> >>
> >>
> >> --
> >> Best regards,
> >>
> >> Shaofeng Shi 史少锋
> >>
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
> >
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re: kylin load hive table rest is error

apache_dev@163.com
In reply to this post by Billy Liu
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



[hidden email]
 
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 [hidden email] <[hidden email]>:
 

> 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.
>
>
>
> [hidden email]
>
> 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 <[hidden email]>:
>
> > Any message in tomcat/logs/* or logs/kylin.out?
> >
> > 2017-08-13 10:21 GMT+08:00 [hidden email] <[hidden email]>:
> >
> >> 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
> >>
> >>
> >>
> >>
> >>
> >> [hidden email]
> >>
> >> 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 [hidden email] <[hidden email]>:
> >>
> >> >
> >> > 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>
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > [hidden email]
> >> >
> >>
> >>
> >>
> >> --
> >> Best regards,
> >>
> >> Shaofeng Shi 史少锋
> >>
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
> >
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re: kylin load hive table rest is error

shaofengshi
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 [hidden email] <[hidden email]>:

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



--
Best regards,

Shaofeng Shi 史少锋
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Re: kylin load hive table rest is error

apache_dev@163.com

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





[hidden email]
 
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 [hidden email] <[hidden email]>:
 

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