Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of dmcnelis@gmail.com designates
 209.85.212.52 as permitted sender)
MIME-Version: 1.0
Date: Fri, 19 Apr 2013 23:36:52 -0500
Message-ID: 
 <CACy0uxmkW9zCp53z+L2O=Rs=7K=+wGhUyf74DAzUmUe-Y3MnXw@mail.gmail.com>
Subject: Building SSTables using SSTableSimpleUnsortedWriter (v. 1.2.3)
From: David McNelis <dmcnelis@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=089e016339be7bc04a04dac36220

--089e016339be7bc04a04dac36220
Content-Type: text/plain; charset=ISO-8859-1

Was trying to do a test of writing SSTs for a CQL3 table.  So I created the
following table:

CREATE TABLE test_sst_load (
  mykey1 ascii,
  mykey2 ascii,
  value1 ascii,
  PRIMARY KEY (mykey1, mykey2)
)

I then set up my writer like so: (moved to gist:
https://gist.github.com/dmcnelis/5424756 )

This created my SST files ok and they imported without throwing any sorts
of errors (had -v and --debug on) when using sstableloader.

When I went to query my data in cqlsh, I got an rpc error.  In my
system.log I saw an exception: java.lang.RuntimeException:
java.lang.IllegalArgumentException
 (also at the gist above).

I had a feeling that it wouldn't work.. but I can't see a way with the
SSTableSimpleUnsortedWriter (or in the AbstractSSTableWriter) to create an
sstable file that is going to work with the CQL3 tables.  I know its got to
be possible, I can import SSTs with the sstableloader from one cluster to
another, where the tables are CQL3.

What am I missing here?

--089e016339be7bc04a04dac36220
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Was trying to do a test of writing SSTs for a CQL3 table. =
=A0So I created the following table:<div><br></div><div><div>CREATE TABLE t=
est_sst_load (</div><div>=A0 mykey1 ascii,</div><div>=A0 mykey2 ascii,</div=
><div>
=A0 value1 ascii,</div><div>=A0 PRIMARY KEY (mykey1, mykey2)</div><div>)=A0=
</div></div><div><br></div><div style>I then set up my writer like so: (mov=
ed to gist:=A0<a href=3D"https://gist.github.com/dmcnelis/5424756">https://=
gist.github.com/dmcnelis/5424756</a> )</div>
<div style><br></div><div style>This created my SST files ok and they impor=
ted without throwing any sorts of errors (had -v and --debug on) when using=
 sstableloader.</div><div style><br></div><div style>When I went to query m=
y data in cqlsh, I got an rpc error. =A0In my system.log I saw an exception=
: java.lang.RuntimeException: java.lang.IllegalArgumentException</div>
<div style>=A0(also at the gist above).</div><div style><br></div><div styl=
e>I had a feeling that it wouldn&#39;t work.. but I can&#39;t see a way wit=
h the SSTableSimpleUnsortedWriter (or in the AbstractSSTableWriter) to crea=
te an sstable file that is going to work with the CQL3 tables. =A0I know it=
s got to be possible, I can import SSTs with the sstableloader from one clu=
ster to another, where the tables are CQL3.</div>
<div style><br></div><div style>What am I missing here?</div><div style><br=
></div><div style><br></div><div style><br></div><div style><br></div></div=
>

--089e016339be7bc04a04dac36220--