SlabTooBig exception


#1

Hello,

I’m trying to replicate the Star Schema Benchmark on a mapd database. It is based on the TPC-H benchmark.

For query 3 I get the SlabTooBig exception
I didn’t find any references to this exception neither in your documentation nor in this forum. Any hint?

Query is:

select c_city, s_city, d_year, sum(lo_revenue) as revenue
from customer, lineorder, supplier, dwdate
where lo_custkey = c_custkey
and lo_suppkey = s_suppkey
and lo_orderdate = d_datekey
and (c_city=‘UNITED KI1’ or
c_city=‘UNITED KI5’)
and (s_city=‘UNITED KI1’ or
s_city=‘UNITED KI5’)
and d_yearmonth = 'Dec1997’
group by c_city, s_city, d_year
order by d_year asc, revenue desc;

Thanks!


MapD CE crashes on relatively small dataset with a star schema (resolved in v 3.3.0)
#2

I also started to get “Broken pipe” errors. And also for queries that “[…] would require a scan without a limit on table(s)”

User mapd connected to database mapd
Thrift: Thu Jul 27 14:59:50 2017 TSocket::write_partial() send() <Host: localhost Port: 9091>Broken pipe
Thrift: Thu Jul 27 14:59:50 2017 TSocket::open() connect() <Host: localhost Port: 9091>Connection refused
Thrift: Thu Jul 27 14:59:50 2017 TSocket::open() connect() <Host: localhost Port: 9091>Connection refused
Thrift error: connect() failed: Connection refused
Thrift: Thu Jul 27 14:59:50 2017 TSocket::open() connect() <Host: localhost Port: 9091>Connection refused
Thrift: Thu Jul 27 14:59:50 2017 TSocket::open() connect() <Host: localhost Port: 9091>Connection refused
Thrift error: connect() failed: Connection refused

Any help is appreciated.

Regards,
Enrique


#3

Hi

What was the scale factor you tried to run this at. What are the details of the machine you tried to execute on (RAM + number of GPU and type)

What version of MapD are you using?

regards


#4

Hi,

I was executing this benchmark on a p2.x instance (61 GB, 1 GPU Tesla K80). By launching MapD AMI (Community) from AWS Marketplace. Version MapD Community Edition - v3-1e20d964-1d79-4290-9751-5af45b74f67b-ami-1128b507.4

Regards


#5

And MapD Server Version is 3.1.2-20170719-9b89178.

Though I also tested mapd-ce-3.1.3-20170727-edbb780-Linux-x86_64-render with similar results (Broken pipe on TSocket::write_partial() send())

Thanks and regards,
Enrique