Re: Re: kylin load hive table rest is error
Analyze tomcat logs,GUI method seems to have more step than rest client .but
rest client get a 500 status.
What's the reason? thinks.
This is tomcat log:
(Kylin GUI load table Log,sucess.)
192.168.224.4 - - [14/Aug/2017:16:26:25 +0800] "GET
/kylin/api/tables?ext=true&project=api HTTP/1.1" 200 2
192.168.224.4 - - [14/Aug/2017:16:26:25 +0800] "GET
/kylin/api/cubes?limit=15&offset=0&projectName=api HTTP/1.1" 200 2
192.168.224.4 - - [14/Aug/2017:16:26:28 +0800] "GET /kylin/api/tables/hive
HTTP/1.1" 200 110
192.168.224.4 - - [14/Aug/2017:16:26:33 +0800] "GET
/kylin/api/tables/hive/metric HTTP/1.1" 200 91
127.0.0.1 - - [14/Aug/2017:16:26:43 +0800] "PUT
/kylin/api/cache/table_ext/METRIC.FACT1/update HTTP/1.1" 500 8766
192.168.224.4 - - [14/Aug/2017:16:26:43 +0800] "POST
/kylin/api/tables/metric.fact1,/api HTTP/1.1" 200 55
127.0.0.1 - - [14/Aug/2017:16:26:43 +0800] "PUT
/kylin/api/cache/table/METRIC.FACT1/update HTTP/1.1" 500 8759
127.0.0.1 - - [14/Aug/2017:16:26:43 +0800] "PUT
/kylin/api/cache/project/api/update HTTP/1.1" 200 -
127.0.0.1 - - [14/Aug/2017:16:26:43 +0800] "PUT
/kylin/api/cache/table_ext/METRIC.FACT1/update HTTP/1.1" 500 8766
192.168.224.4 - - [14/Aug/2017:16:26:43 +0800] "GET
/kylin/api/tables?ext=true&project=api HTTP/1.1" 200 665
127.0.0.1 - - [14/Aug/2017:16:27:32 +0800] "PUT
/kylin/api/cache/table_ext/METRIC.FACT1/update HTTP/1.1" 500 8766
(rest load table log,failed)
192.168.224.4 - - [14/Aug/2017:16:27:56 +0800] "POST
/kylin/api/tables/metric.fact2,/api HTTP/1.1" 500 148
apache_...@163.com
From: ShaoFeng Shi
Date: 2017-08-14 13:33
To: dev
Subject: Re: Re: kylin load hive table rest is error
Kylin Web GUI calls the same REST API; So if Kylin GUI works, you need
check your script. You can open the debug mode of browser to see the detail
HTTP request header/body, and then use the same in your script.
2017-08-14 11:36 GMT+08:00 apache_...@163.com :
> Yes.
>
> metric.date_dim is table name in hive
>
> load is kylin project.
>
> Executing it in two environments have same error.
>
> Kylin version:2.0
>
> red part is tomcat log:
> xx.xx.xx.xx - - [14/Aug/2017:11:37:58 +0800] "GET
> /kylin/api/cubes/validEncodings
> HTTP/1.1" 200 98
> xx.xx.xx.xx - - [14/Aug/2017:11:39:25 +0800] "POST
> /kylin/api/tables/metric.date_dim/load HTTP/1.1" 500 9919
>
>
>
> apache_...@163.com
>
> From: Billy Liu
> Date: 2017-08-13 23:35
> To: dev
> Subject: Re: Re: kylin load hive table rest is error
> As the document says {tables} and {project} are path parameters, so in your
> case, is metric.date_dim the table name, and load the project name?
>
> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
>
> 2017-08-13 22:28 GMT+08:00 apache_...@163.com :
>
> > it can work by Kylin GUI.
> >
> > I refer to the API document,but is not work.
> >
> > Load Hive Tables
> > POST /kylin/api/tables/{tables}/{project}
> > Request Parameters
> > tables - required string table names you want to load from hive,
> separated
> > with comma.
> > project - required String the project which the tables will be loaded
> into.
> >
> >
> >
> > apache_...@163.com
> >
> > From: ShaoFeng Shi
> > Date: 2017-08-13 14:23
> > To: dev
> > Subject: Re: Re: kylin load hive table rest is error
> > Besides, can you sync the table from Kylin GUI? If GUI doesn't work
> either,
> > that should be env problem. Otherwise it would be API usage mistake.
> >
> > 2017-08-13 14:22 GMT+08:00 ShaoFeng Shi :
> >
> > > Any message in tomcat/logs/* or logs/kylin.out?
> > >
> > > 2017-08-13 10:21 GMT+08:00 apache_...@163.com :
> > >
> > >> Hi,shaofeng:
> > >>
> > >> Kylin2.0 on HDP2.5.3.
> > >>
> > >>
> > >> hive> use metric;
> > >> OK
> > >> Time taken: 0.029 seconds
> > >> hive> show tables;
> > >> OK
> > >> buss_info
> > >> dim
> > >> dim_curr
> > >> dim_date
> > >> dim_dtyp
> > >> dim_gl_acc
> > >> dim_org
> > >> fact1
> > >> fact2
> > >> Time taken: 0.245 seconds, Fetched: 9 row(s)
> > >>
> > >> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
> > >> dim/load
> > >> return error:
> > >> Server returned HTTP response code: 500 for URL:
> > >> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
> >
Re: Re: kylin load hive table rest is error
Kylin Web GUI calls the same REST API; So if Kylin GUI works, you need
check your script. You can open the debug mode of browser to see the detail
HTTP request header/body, and then use the same in your script.
2017-08-14 11:36 GMT+08:00 apache_...@163.com :
> Yes.
>
> metric.date_dim is table name in hive
>
> load is kylin project.
>
> Executing it in two environments have same error.
>
> Kylin version:2.0
>
> red part is tomcat log:
> xx.xx.xx.xx - - [14/Aug/2017:11:37:58 +0800] "GET
> /kylin/api/cubes/validEncodings
> HTTP/1.1" 200 98
> xx.xx.xx.xx - - [14/Aug/2017:11:39:25 +0800] "POST
> /kylin/api/tables/metric.date_dim/load HTTP/1.1" 500 9919
>
>
>
> apache_...@163.com
>
> From: Billy Liu
> Date: 2017-08-13 23:35
> To: dev
> Subject: Re: Re: kylin load hive table rest is error
> As the document says {tables} and {project} are path parameters, so in your
> case, is metric.date_dim the table name, and load the project name?
>
> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
>
> 2017-08-13 22:28 GMT+08:00 apache_...@163.com :
>
> > it can work by Kylin GUI.
> >
> > I refer to the API document,but is not work.
> >
> > Load Hive Tables
> > POST /kylin/api/tables/{tables}/{project}
> > Request Parameters
> > tables - required string table names you want to load from hive,
> separated
> > with comma.
> > project - required String the project which the tables will be loaded
> into.
> >
> >
> >
> > apache_...@163.com
> >
> > From: ShaoFeng Shi
> > Date: 2017-08-13 14:23
> > To: dev
> > Subject: Re: Re: kylin load hive table rest is error
> > Besides, can you sync the table from Kylin GUI? If GUI doesn't work
> either,
> > that should be env problem. Otherwise it would be API usage mistake.
> >
> > 2017-08-13 14:22 GMT+08:00 ShaoFeng Shi :
> >
> > > Any message in tomcat/logs/* or logs/kylin.out?
> > >
> > > 2017-08-13 10:21 GMT+08:00 apache_...@163.com :
> > >
> > >> Hi,shaofeng:
> > >>
> > >> Kylin2.0 on HDP2.5.3.
> > >>
> > >>
> > >> hive> use metric;
> > >> OK
> > >> Time taken: 0.029 seconds
> > >> hive> show tables;
> > >> OK
> > >> buss_info
> > >> dim
> > >> dim_curr
> > >> dim_date
> > >> dim_dtyp
> > >> dim_gl_acc
> > >> dim_org
> > >> fact1
> > >> fact2
> > >> Time taken: 0.245 seconds, Fetched: 9 row(s)
> > >>
> > >> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
> > >> dim/load
> > >> return error:
> > >> Server returned HTTP response code: 500 for URL:
> > >> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
> > >>
> > >> but no relevant logs in kylin.log
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> apache_...@163.com
> > >>
> > >> From: ShaoFeng Shi
> > >> Date: 2017-08-12 14:59
> > >> To: dev
> > >> Subject: Re: kylin load hive table rest is error
> > >> Is there any clue in kylin.log?
> > >>
> > >> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
> > >>
> > >> >
> > >> > 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:
> > >> >
> > >> >
> > >> > > >> > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> > > type="image/x-icon">
> > >> > Kylin
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> > > >> > ng-include="
Re: Re: kylin load hive table rest is error
Yes.
metric.date_dim is table name in hive
load is kylin project.
Executing it in two environments have same error.
Kylin version:2.0
red part is tomcat log:
xx.xx.xx.xx - - [14/Aug/2017:11:37:58 +0800] "GET
/kylin/api/cubes/validEncodings HTTP/1.1" 200 98
xx.xx.xx.xx - - [14/Aug/2017:11:39:25 +0800] "POST
/kylin/api/tables/metric.date_dim/load HTTP/1.1" 500 9919
apache_...@163.com
From: Billy Liu
Date: 2017-08-13 23:35
To: dev
Subject: Re: Re: kylin load hive table rest is error
As the document says {tables} and {project} are path parameters, so in your
case, is metric.date_dim the table name, and load the project name?
http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
2017-08-13 22:28 GMT+08:00 apache_...@163.com :
> it can work by Kylin GUI.
>
> I refer to the API document,but is not work.
>
> Load Hive Tables
> POST /kylin/api/tables/{tables}/{project}
> Request Parameters
> tables - required string table names you want to load from hive, separated
> with comma.
> project - required String the project which the tables will be loaded into.
>
>
>
> apache_...@163.com
>
> From: ShaoFeng Shi
> Date: 2017-08-13 14:23
> To: dev
> Subject: Re: Re: kylin load hive table rest is error
> Besides, can you sync the table from Kylin GUI? If GUI doesn't work either,
> that should be env problem. Otherwise it would be API usage mistake.
>
> 2017-08-13 14:22 GMT+08:00 ShaoFeng Shi :
>
> > Any message in tomcat/logs/* or logs/kylin.out?
> >
> > 2017-08-13 10:21 GMT+08:00 apache_...@163.com :
> >
> >> Hi,shaofeng:
> >>
> >> Kylin2.0 on HDP2.5.3.
> >>
> >>
> >> hive> use metric;
> >> OK
> >> Time taken: 0.029 seconds
> >> hive> show tables;
> >> OK
> >> buss_info
> >> dim
> >> dim_curr
> >> dim_date
> >> dim_dtyp
> >> dim_gl_acc
> >> dim_org
> >> fact1
> >> fact2
> >> Time taken: 0.245 seconds, Fetched: 9 row(s)
> >>
> >> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
> >> dim/load
> >> return error:
> >> Server returned HTTP response code: 500 for URL:
> >> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
> >>
> >> but no relevant logs in kylin.log
> >>
> >>
> >>
> >>
> >>
> >> apache_...@163.com
> >>
> >> From: ShaoFeng Shi
> >> Date: 2017-08-12 14:59
> >> To: dev
> >> Subject: Re: kylin load hive table rest is error
> >> Is there any clue in kylin.log?
> >>
> >> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
> >>
> >> >
> >> > 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:
> >> >
> >> >
> >> > >> > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > type="image/x-icon">
> >> > Kylin
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > >> > ng-include="'partials/header.html'">
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > >> > ng-include="'partials/footer.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>
> >> >
> >> >
> >> > <div class="ca
Re: Re: kylin load hive table rest is error
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
apache_...@163.com
From: Billy Liu
Date: 2017-08-13 23:35
To: dev
Subject: Re: Re: kylin load hive table rest is error
As the document says {tables} and {project} are path parameters, so in your
case, is metric.date_dim the table name, and load the project name?
http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
2017-08-13 22:28 GMT+08:00 apache_...@163.com :
> it can work by Kylin GUI.
>
> I refer to the API document,but is not work.
>
> Load Hive Tables
> POST /kylin/api/tables/{tables}/{project}
> Request Parameters
> tables - required string table names you want to load from hive, separated
> with comma.
> project - required String the project which the tables will be loaded into.
>
>
>
> apache_...@163.com
>
> From: ShaoFeng Shi
> Date: 2017-08-13 14:23
> To: dev
> Subject: Re: Re: kylin load hive table rest is error
> Besides, can you sync the table from Kylin GUI? If GUI doesn't work either,
> that should be env problem. Otherwise it would be API usage mistake.
>
> 2017-08-13 14:22 GMT+08:00 ShaoFeng Shi :
>
> > Any message in tomcat/logs/* or logs/kylin.out?
> >
> > 2017-08-13 10:21 GMT+08:00 apache_...@163.com :
> >
> >> Hi,shaofeng:
> >>
> >> Kylin2.0 on HDP2.5.3.
> >>
> >>
> >> hive> use metric;
> >> OK
> >> Time taken: 0.029 seconds
> >> hive> show tables;
> >> OK
> >> buss_info
> >> dim
> >> dim_curr
> >> dim_date
> >> dim_dtyp
> >> dim_gl_acc
> >> dim_org
> >> fact1
> >> fact2
> >> Time taken: 0.245 seconds, Fetched: 9 row(s)
> >>
> >> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
> >> dim/load
> >> return error:
> >> Server returned HTTP response code: 500 for URL:
> >> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
> >>
> >> but no relevant logs in kylin.log
> >>
> >>
> >>
> >>
> >>
> >> apache_...@163.com
> >>
> >> From: ShaoFeng Shi
> >> Date: 2017-08-12 14:59
> >> To: dev
> >> Subject: Re: kylin load hive table rest is error
> >> Is there any clue in kylin.log?
> >>
> >> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
> >>
> >> >
> >> > 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:
> >> >
> >> >
> >> > >> > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > type="image/x-icon">
> >> > Kylin
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > >> > ng-include="'partials/header.html'">
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > >> > ng-include="'partials/footer.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>
> >> >
> >> >
> >> > <div class="callout callout-info">
> >> > <p>{{text}}</p>
> >> > </div>
> >> >
> >> >
> >> >
> >> >
> >> > <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>
> >> >
> >> >
> >> > <div class="callout callout-info">
> >> > <p>{{text}}</p>
> >> > </div>
> >> >
> >> >
> >> >
> >> > <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>
> >> >
> >> >
> >> > <div class="callout callout-info">
> >> > <p>{{text}}</p>
> >> > </div>
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > apache_...@163.com
> >> >
> >>
> >>
> >>
> >> --
> >> Best regards,
> >>
> >> Shaofeng Shi 史少锋
> >>
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
> >
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
Re: Re: kylin load hive table rest is error
As the document says {tables} and {project} are path parameters, so in your
case, is metric.date_dim the table name, and load the project name?
http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
2017-08-13 22:28 GMT+08:00 apache_...@163.com :
> it can work by Kylin GUI.
>
> I refer to the API document,but is not work.
>
> Load Hive Tables
> POST /kylin/api/tables/{tables}/{project}
> Request Parameters
> tables - required string table names you want to load from hive, separated
> with comma.
> project - required String the project which the tables will be loaded into.
>
>
>
> apache_...@163.com
>
> From: ShaoFeng Shi
> Date: 2017-08-13 14:23
> To: dev
> Subject: Re: Re: kylin load hive table rest is error
> Besides, can you sync the table from Kylin GUI? If GUI doesn't work either,
> that should be env problem. Otherwise it would be API usage mistake.
>
> 2017-08-13 14:22 GMT+08:00 ShaoFeng Shi :
>
> > Any message in tomcat/logs/* or logs/kylin.out?
> >
> > 2017-08-13 10:21 GMT+08:00 apache_...@163.com :
> >
> >> Hi,shaofeng:
> >>
> >> Kylin2.0 on HDP2.5.3.
> >>
> >>
> >> hive> use metric;
> >> OK
> >> Time taken: 0.029 seconds
> >> hive> show tables;
> >> OK
> >> buss_info
> >> dim
> >> dim_curr
> >> dim_date
> >> dim_dtyp
> >> dim_gl_acc
> >> dim_org
> >> fact1
> >> fact2
> >> Time taken: 0.245 seconds, Fetched: 9 row(s)
> >>
> >> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
> >> dim/load
> >> return error:
> >> Server returned HTTP response code: 500 for URL:
> >> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
> >>
> >> but no relevant logs in kylin.log
> >>
> >>
> >>
> >>
> >>
> >> apache_...@163.com
> >>
> >> From: ShaoFeng Shi
> >> Date: 2017-08-12 14:59
> >> To: dev
> >> Subject: Re: kylin load hive table rest is error
> >> Is there any clue in kylin.log?
> >>
> >> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
> >>
> >> >
> >> > 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:
> >> >
> >> >
> >> > >> > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > type="image/x-icon">
> >> > Kylin
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > >> > ng-include="'partials/header.html'">
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > >> > ng-include="'partials/footer.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>
> >> >
> >> >
> >> > <div class="callout callout-info">
> >> > <p>{{text}}</p>
> >> > </div>
> >> >
> >> >
> >> >
> >> >
> >> > <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>
> >> >
> >> >
> >> > <div class="callout callout-info">
> >> > <p>{{text}}</p>
> >> > </div>
> >> >
> >> >
> >> >
> >> > <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>
> >> >
> >> >
> >> > <div class="callout callout-info">
> >> > <p>{{text}}</p>
> >> > </div>
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > apache_...@163.com
> >> >
> >>
> >>
> >>
> >> --
> >> Best regards,
> >>
> >> Shaofeng Shi 史少锋
> >>
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
> >
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
Re: Re: kylin load hive table rest is error
it can work by Kylin GUI.
I refer to the API document,but is not work.
Load Hive Tables
POST /kylin/api/tables/{tables}/{project}
Request Parameters
tables - required string table names you want to load from hive, separated with
comma.
project - required String the project which the tables will be loaded into.
apache_...@163.com
From: ShaoFeng Shi
Date: 2017-08-13 14:23
To: dev
Subject: Re: Re: kylin load hive table rest is error
Besides, can you sync the table from Kylin GUI? If GUI doesn't work either,
that should be env problem. Otherwise it would be API usage mistake.
2017-08-13 14:22 GMT+08:00 ShaoFeng Shi :
> Any message in tomcat/logs/* or logs/kylin.out?
>
> 2017-08-13 10:21 GMT+08:00 apache_...@163.com :
>
>> Hi,shaofeng:
>>
>> Kylin2.0 on HDP2.5.3.
>>
>>
>> hive> use metric;
>> OK
>> Time taken: 0.029 seconds
>> hive> show tables;
>> OK
>> buss_info
>> dim
>> dim_curr
>> dim_date
>> dim_dtyp
>> dim_gl_acc
>> dim_org
>> fact1
>> fact2
>> Time taken: 0.245 seconds, Fetched: 9 row(s)
>>
>> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
>> dim/load
>> return error:
>> Server returned HTTP response code: 500 for URL:
>> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
>>
>> but no relevant logs in kylin.log
>>
>>
>>
>>
>>
>> apache_...@163.com
>>
>> From: ShaoFeng Shi
>> Date: 2017-08-12 14:59
>> To: dev
>> Subject: Re: kylin load hive table rest is error
>> Is there any clue in kylin.log?
>>
>> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
>>
>> >
>> > 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:
>> >
>> >
>> > > > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > Kylin
>> >
>> >
>> >
>> >
>> >
>> > > > ng-include="'partials/header.html'">
>> >
>> >
>> >
>> >
>> >
>> > > > ng-include="'partials/footer.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>
>> >
>> >
>> > <div class="callout callout-info">
>> > <p>{{text}}</p>
>> > </div>
>> >
>> >
>> >
>> >
>> > <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>
>> >
>> >
>> > <div class="callout callout-info">
>> > <p>{{text}}</p>
>> > </div>
>> >
>> >
>> >
>> > <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>
>> >
>> >
>> > <div class="callout callout-info">
>> > <p>{{text}}</p>
>> > </div>
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > apache_...@163.com
>> >
>>
>>
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi 史少锋
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>
--
Best regards,
Shaofeng Shi 史少锋
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 :
> Any message in tomcat/logs/* or logs/kylin.out?
>
> 2017-08-13 10:21 GMT+08:00 apache_...@163.com :
>
>> Hi,shaofeng:
>>
>> Kylin2.0 on HDP2.5.3.
>>
>>
>> hive> use metric;
>> OK
>> Time taken: 0.029 seconds
>> hive> show tables;
>> OK
>> buss_info
>> dim
>> dim_curr
>> dim_date
>> dim_dtyp
>> dim_gl_acc
>> dim_org
>> fact1
>> fact2
>> Time taken: 0.245 seconds, Fetched: 9 row(s)
>>
>> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
>> dim/load
>> return error:
>> Server returned HTTP response code: 500 for URL:
>> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
>>
>> but no relevant logs in kylin.log
>>
>>
>>
>>
>>
>> apache_...@163.com
>>
>> From: ShaoFeng Shi
>> Date: 2017-08-12 14:59
>> To: dev
>> Subject: Re: kylin load hive table rest is error
>> Is there any clue in kylin.log?
>>
>> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
>>
>> >
>> > 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:
>> >
>> >
>> > > > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > Kylin
>> >
>> >
>> >
>> >
>> >
>> > > > ng-include="'partials/header.html'">
>> >
>> >
>> >
>> >
>> >
>> > > > ng-include="'partials/footer.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>
>> >
>> >
>> > <div class="callout callout-info">
>> > <p>{{text}}</p>
>> > </div>
>> >
>> >
>> >
>> >
>> > <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>
>> >
>> >
>> > <div class="callout callout-info">
>> > <p>{{text}}</p>
>> > </div>
>> >
>> >
>> >
>> > <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>
>> >
>> >
>> > <div class="callout callout-info">
>> > <p>{{text}}</p>
>> > </div>
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > apache_...@163.com
>> >
>>
>>
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi 史少锋
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>
--
Best regards,
Shaofeng Shi 史少锋
Re: Re: kylin load hive table rest is error
Any message in tomcat/logs/* or logs/kylin.out?
2017-08-13 10:21 GMT+08:00 apache_...@163.com :
> Hi,shaofeng:
>
> Kylin2.0 on HDP2.5.3.
>
>
> hive> use metric;
> OK
> Time taken: 0.029 seconds
> hive> show tables;
> OK
> buss_info
> dim
> dim_curr
> dim_date
> dim_dtyp
> dim_gl_acc
> dim_org
> fact1
> fact2
> Time taken: 0.245 seconds, Fetched: 9 row(s)
>
> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/
> load
> return error:
> Server returned HTTP response code: 500 for URL:
> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
>
> but no relevant logs in kylin.log
>
>
>
>
>
> apache_...@163.com
>
> From: ShaoFeng Shi
> Date: 2017-08-12 14:59
> To: dev
> Subject: Re: kylin load hive table rest is error
> Is there any clue in kylin.log?
>
> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
>
> >
> > 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:
> >
> >
> > > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
> >
> >
> >
> >
> >
> >
> >
> >
> > Kylin
> >
> >
> >
> >
> >
> > > ng-include="'partials/header.html'">
> >
> >
> >
> >
> >
> > > ng-include="'partials/footer.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>
> >
> >
> > <div class="callout callout-info">
> > <p>{{text}}</p>
> > </div>
> >
> >
> >
> >
> > <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>
> >
> >
> > <div class="callout callout-info">
> > <p>{{text}}</p>
> > </div>
> >
> >
> >
> > <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>
> >
> >
> > <div class="callout callout-info">
> > <p>{{text}}</p>
> > </div>
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > apache_...@163.com
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
--
Best regards,
Shaofeng Shi 史少锋
Re: Re: kylin load hive table rest is error
Hi,shaofeng:
Kylin2.0 on HDP2.5.3.
hive> use metric;
OK
Time taken: 0.029 seconds
hive> show tables;
OK
buss_info
dim
dim_curr
dim_date
dim_dtyp
dim_gl_acc
dim_org
fact1
fact2
Time taken: 0.245 seconds, Fetched: 9 row(s)
post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
return error:
Server returned HTTP response code: 500 for URL:
http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
but no relevant logs in kylin.log
apache_...@163.com
From: ShaoFeng Shi
Date: 2017-08-12 14:59
To: dev
Subject: Re: kylin load hive table rest is error
Is there any clue in kylin.log?
2017-08-12 9:58 GMT+08:00 apache_...@163.com :
>
> 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:
>
>
> http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
>
>
>
>
>
>
>
>
> Kylin
>
>
>
>
>
> ng-include="'partials/header.html'">
>
>
>
>
>
> ng-include="'partials/footer.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>
>
>
> <div class="callout callout-info">
> <p>{{text}}</p>
> </div>
>
>
>
>
> <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>
>
>
> <div class="callout callout-info">
> <p>{{text}}</p>
> </div>
>
>
>
> <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>
>
>
> <div class="callout callout-info">
> <p>{{text}}</p>
> </div>
>
>
>
>
>
>
>
>
>
>
> apache_...@163.com
>
--
Best regards,
Shaofeng Shi 史少锋
Re: kylin load hive table rest is error
Is there any clue in kylin.log? 2017-08-12 9:58 GMT+08:00 apache_...@163.com : > > 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: > > > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> > > > > > > > > > Kylin > > > > > > ng-include="'partials/header.html'"> > > > > > > ng-include="'partials/footer.html'"> > > > > >>>Error Message
>{{text}}
>>> > >Cube Schema
>{{schema}}>>> > > > >{{text}}
>>>Error Message
>{{text}}
>>> > >Model Schema
>{{schema}}>>> > > >{{text}}
>>>Error Message
>{{text}}
>>>Streaming Schema
>{{streamingSchema}}>>> > >Kafka Schema
>{{kfkSchema}}>>> > > > > > > > > > > apache_...@163.com > -- Best regards, Shaofeng Shi 史少锋{{text}}
>
kylin load hive table rest is error
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: KylinError Message
{{text}}
Cube Schema
{{schema}}{{text}}
Error Message
{{text}}
Model Schema
{{schema}}{{text}}
Error Message
{{text}}
Streaming Schema
{{streamingSchema}}Kafka Schema
{{kfkSchema}}apache_...@163.com{{text}}
kylin load hive table rest is error
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: KylinError Message
{{text}}
Cube Schema
{{schema}}{{text}}
Error Message
{{text}}
Model Schema
{{schema}}{{text}}
Error Message
{{text}}
Streaming Schema
{{streamingSchema}}Kafka Schema
{{kfkSchema}}apache_...@163.com{{text}}
