cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Lowenthal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-5336) C* crashes with an OOM error when using the Simba Driver on a very wide table
Date Tue, 12 Mar 2013 23:15:12 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-5336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13600600#comment-13600600
] 

Steven Lowenthal commented on CASSANDRA-5336:
---------------------------------------------

I think a simple select count(*) from <table> limit 10000;   will do it.  The trace
was produced with a simpler tool "nettool".  It's very handy.  That begs the question of building
a thrift trace / playback tool.  It may be helpful for support and load testing.
                
> C* crashes with an OOM error when using the Simba Driver on a very wide table
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-5336
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5336
>             Project: Cassandra
>          Issue Type: Bug
>          Components: API
>    Affects Versions: 1.1.6
>         Environment: C* on a Mac with 1GB VM.  Simba ODBC driver
>            Reporter: Steven Lowenthal
>         Attachments: nhanes600-10k.tarZ, thrift.in, thrift.out
>
>
> The Simba driver executes a version of a count(*) query:
> SELECT SUM(1) from nhanes3 having sum(1) > 0.   It uses this format so ODBC returns
a no rows found error if the table is empty.   It translates into a series of get_range_slice
calls which bring back all of the rows, and for every row, it brings back every single column
name.   C* crashes with an OOM in the thrift code.  The table has almost 600 columns of mixed
text and numeric data with many empty values.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message