You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by rahulsingh <ra...@i-link.co.in> on 2017/04/25 10:25:30 UTC

Server goes down while Tableau query is running

Hi all,

I am facing issue when Tableau 10.2 runs query, the kylin node going down
whenever Tableau runs query.
I am not understanding what is the actual issue? Should we load the whole
data in Tableau then prepare a sheet or something other than this. 

Whenever I check the kylin logs I am getting below exception.

2017-04-24 23:55:06,074 INFO  [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 1881.406 seconds
(project:MyTaxMarketing, thread: 0x79, user:ANALYST) -- SELECT * FROM
"DEFAULT"."Tablename"
2017-04-24 23:55:30,967 DEBUG [BadQueryDetector]
badquery.BadQueryHistoryManager:84 : Loaded 10 Bad Query(s)
2017-04-24 23:56:05,746 DEBUG [BadQueryDetector]
hbase.HBaseResourceStore:262 : Update row /bad_query/******.json from oldTs:
1493103211146, to newTs: 1493103330968, operation result: true
2017-04-24 23:56:57,935 INFO  [BadQueryDetector]
service.BadQueryDetector:169 : Problematic thread 0x79
	at java.nio.HeapByteBuffer.slice(HeapByteBuffer.java:98)
	at org.apache.kylin.common.util.ByteArray.asBuffer(ByteArray.java:136)
	at org.apache.kylin.gridtable.GTRecord.getValues(GTRecord.java:129)
	at
org.apache.kylin.storage.gtrecord.CubeTupleConverter.translateResult(CubeTupleConverter.java:207)
	at
org.apache.kylin.storage.gtrecord.SegmentCubeTupleIterator.hasNext(SegmentCubeTupleIterator.java:100)
	at com.google.common.collect.Iterators$5.hasNext(Iterators.java:596)
	at
org.apache.kylin.storage.gtrecord.SequentialCubeTupleIterator.hasNext(SequentialCubeTupleIterator.java:84)
	at
org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:68)
	at
org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.next(Linq4j.java:673)
	at
org.apache.calcite.avatica.util.IteratorCursor.next(IteratorCursor.java:46)

Thank You,
Rahul Singh

--
View this message in context: http://apache-kylin.74782.x6.nabble.com/Server-goes-down-while-Tableau-query-is-running-tp7764.html
Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Server goes down while Tableau query is running

Posted by Li Yang <li...@apache.org>.
The query is taking long to run, which means either the cube needs tuning,
or the cluster capacity is running low.

On Tue, Apr 25, 2017 at 6:25 PM, rahulsingh <ra...@i-link.co.in>
wrote:

> Hi all,
>
> I am facing issue when Tableau 10.2 runs query, the kylin node going down
> whenever Tableau runs query.
> I am not understanding what is the actual issue? Should we load the whole
> data in Tableau then prepare a sheet or something other than this.
>
> Whenever I check the kylin logs I am getting below exception.
>
> 2017-04-24 23:55:06,074 INFO  [BadQueryDetector]
> service.BadQueryDetector:179 : Slow query has been running 1881.406 seconds
> (project:MyTaxMarketing, thread: 0x79, user:ANALYST) -- SELECT * FROM
> "DEFAULT"."Tablename"
> 2017-04-24 23:55:30,967 DEBUG [BadQueryDetector]
> badquery.BadQueryHistoryManager:84 : Loaded 10 Bad Query(s)
> 2017-04-24 23:56:05,746 DEBUG [BadQueryDetector]
> hbase.HBaseResourceStore:262 : Update row /bad_query/******.json from
> oldTs:
> 1493103211146, to newTs: 1493103330968, operation result: true
> 2017-04-24 23:56:57,935 INFO  [BadQueryDetector]
> service.BadQueryDetector:169 : Problematic thread 0x79
>         at java.nio.HeapByteBuffer.slice(HeapByteBuffer.java:98)
>         at org.apache.kylin.common.util.ByteArray.asBuffer(ByteArray.
> java:136)
>         at org.apache.kylin.gridtable.GTRecord.getValues(GTRecord.
> java:129)
>         at
> org.apache.kylin.storage.gtrecord.CubeTupleConverter.translateResult(
> CubeTupleConverter.java:207)
>         at
> org.apache.kylin.storage.gtrecord.SegmentCubeTupleIterator.hasNext(
> SegmentCubeTupleIterator.java:100)
>         at com.google.common.collect.Iterators$5.hasNext(Iterators.
> java:596)
>         at
> org.apache.kylin.storage.gtrecord.SequentialCubeTupleIterator.hasNext(
> SequentialCubeTupleIterator.java:84)
>         at
> org.apache.kylin.query.enumerator.OLAPEnumerator.
> moveNext(OLAPEnumerator.java:68)
>         at
> org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.next(Linq4j.java:673)
>         at
> org.apache.calcite.avatica.util.IteratorCursor.next(
> IteratorCursor.java:46)
>
> Thank You,
> Rahul Singh
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/Server-goes-down-while-Tableau-query-is-running-tp7764.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>