You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "13802880779@139.com" <13...@139.com> on 2015/09/09 08:18:01 UTC
jdbc do not return all the results
the jdbc code like:
Driver driver = (Driver) Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
Properties info = new Properties();
info.put("user", "ADMIN");
info.put("password", "KYLIN");
Connection conn = driver.connect("jdbc:kylin://localhost:7070/kylin_project_name", info);
Statement state = conn.createStatement();
ResultSet resultSet = state.executeQuery("select * from test_table");
while (resultSet.next()) {.....}the same query, jdbc returns 5 rows, but in kylin's own query tab, after click showall button,it returns 15 rows, how to make jdbc return all?
中国移动广东有限公司 网管中心 梁猛
13802880779@139.com
Re: jdbc do not return all the results
Posted by hongbin ma <ma...@apache.org>.
there is a rest call to the KYLIN server for each query through JDBC
you can check the kylin.log in rest server
On Wed, Sep 9, 2015 at 2:54 PM, Jian Zhong <he...@gmail.com> wrote:
> Hi Meng,
>
> First,for query on web UI, it's not supposed to return partial result since
> there only 15 rows,
>
> And, for jdbc connection, query should return all results by default, can
> you provide more log for us to analysis.
>
> On Wed, Sep 9, 2015 at 2:18 PM, 13802880779@139.com <13...@139.com>
> wrote:
>
> > the jdbc code like:
> > Driver driver = (Driver)
> > Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
> > Properties info = new Properties();
> > info.put("user", "ADMIN");
> > info.put("password", "KYLIN");
> > Connection conn =
> > driver.connect("jdbc:kylin://localhost:7070/kylin_project_name", info);
> > Statement state = conn.createStatement();
> > ResultSet resultSet = state.executeQuery("select * from
> > test_table");
> > while (resultSet.next()) {.....}the same query, jdbc returns 5
> > rows, but in kylin's own query tab, after click showall button,it returns
> > 15 rows, how to make jdbc return all?
> >
> >
> >
> > 中国移动广东有限公司 网管中心 梁猛
> > 13802880779@139.com
> >
>
--
Regards,
*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone
Re: jdbc do not return all the results
Posted by Jian Zhong <he...@gmail.com>.
Hi Meng,
First,for query on web UI, it's not supposed to return partial result since
there only 15 rows,
And, for jdbc connection, query should return all results by default, can
you provide more log for us to analysis.
On Wed, Sep 9, 2015 at 2:18 PM, 13802880779@139.com <13...@139.com>
wrote:
> the jdbc code like:
> Driver driver = (Driver)
> Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
> Properties info = new Properties();
> info.put("user", "ADMIN");
> info.put("password", "KYLIN");
> Connection conn =
> driver.connect("jdbc:kylin://localhost:7070/kylin_project_name", info);
> Statement state = conn.createStatement();
> ResultSet resultSet = state.executeQuery("select * from
> test_table");
> while (resultSet.next()) {.....}the same query, jdbc returns 5
> rows, but in kylin's own query tab, after click showall button,it returns
> 15 rows, how to make jdbc return all?
>
>
>
> 中国移动广东有限公司 网管中心 梁猛
> 13802880779@139.com
>