cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christopher J. Bottaro (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-5991) COPY FROM failing on maps with "Unmatched named substitution"
Date Mon, 09 Sep 2013 22:42:53 GMT
Christopher J. Bottaro created CASSANDRA-5991:
-------------------------------------------------

             Summary: COPY FROM failing on maps with "Unmatched named substitution"
                 Key: CASSANDRA-5991
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5991
             Project: Cassandra
          Issue Type: Bug
         Environment: Cassandra 1.2.9 installed via Homebrew on OS X.
            Reporter: Christopher J. Bottaro


I created a dump using COPY TO, but then the dump won't load with COPY FROM.

$ echo "COPY applications TO 'dev_development.csv';" | cqlsh -k dev_development localhost
776 rows exported in 7.935 seconds.

$ echo "COPY applications FROM 'dev_development.csv';" | cqlsh -k beta_development localhost
<stdin>:2:Unmatched named substitution: '27' not given for 'INSERT INTO beta_development.applications
(version, id, answers) VALUES (\'2013-01-22 13:52:11-0600\', 219, {1: \'{"result":"Izaiah"}\',
2: \'{"result":"Maegan"}\', 3: \'{"result":"Bergstrom"}\', 4: \'{"result":"1-617-729-8621
x05429"}\', 5: \'{"result":"Mailing/Shipping Address"}\', 6: \'{"result":"257 O\'Reilly Tunnel"}\',
7: \'{"result":null}\', 8: \'{"result":"Sauerberg"}\', 9: \'{"result":null}\', 10: \'{"result":"Washington"}\',
11: \'{"result":"99043-3492"}\', 12: \'{"result":"Peru"}\', 13: \'{"result":null}\', 14: \'{"result":"Male"}\',
15: \'{"result":"6/5/1980"}\', 16: \'{"result":"American Indian or Alaska Native (not Hispanic
or Latino)"}\', 17: \'{"result":"Refugee or Protected Person"}\', 18: \'{"result":"5/10/2011"}\',
19: \'{"result":["Indiana University-South Bend","IVY Tech-South Bend"]}\', 20: \'{"result":["Band","Basketball","Hockey"]}\',
21: \'{"result":"Robertsville"}\', 22: \'{"result":null}\', 23: \'{"result":"OH"}\', 24: \'{"result":"83615-4544"}\',
25: \'{"result":"Planning to file"}\', 26: \'{"result":[]}\', 27: \'{"result":null}\', 28:
\'{"result":null}\', 29: \'{"result":"Nemo odio et repellendus dolores quis non ut. Ut sint
labore nostrum. Quo odit at explicabo veniam necessitatibus error aliquid.<br />Magni
saepe nam et deleniti. Laudantium aut rerum accusantium voluptatem voluptas. Incidunt facere
rerum veritatis aliquid deleniti ut. Qui non ea dicta officiis deserunt.<br />Aut voluptas
sapiente non omnis optio illum laboriosam. Voluptatem veritatis quibusdam aperiam. Vero ipsum
facere accusamus aut cumque vel.<br />Dolorem tenetur ut occaecati quia eos assumenda.
Officiis doloribus similique id harum corporis quas. Quis occaecati sint aut fugiat ut nisi
voluptas culpa. Ea illo maxime ut nobis beatae qui. Velit est quasi earum autem totam ab repudiandae
fuga.<br />Maiores sint et sed. Non fugit esse molestiae. Eum praesentium quae sapiente
repellendus. Aut ipsam alias dolor ducimus eum debitis eaque id.<br />Et provident ad
ut ullam mollitia laboriosam doloremque ex. Quo quia id qui omnis quos numquam. Cum ratione
ab est. Quia aspernatur et cum iusto voluptas saepe voluptatem. Veniam et doloribus quam.<br
/>Exercitationem quis reiciendis explicabo assumenda. Amet sit consequatur enim aut et
veniam quia. Inventore et iusto autem ea praesentium voluptates. Nostrum vel minima quasi
recusandae. Vel enim veniam omnis.<br />Consequuntur modi laborum est aut repellendus
occaecati. Vero hic mollitia consequuntur. Quas quia ut et. Sed sunt unde dolore. Explicabo
amet error sunt.<br />Sunt cupiditate provident aut. Aliquam suscipit quaerat culpa
consectetur ab. Et optio nesciunt impedit doloremque quis facere quae dolorum."}\', 32: \'{"result":"678"}\',
33: \'{"result":"84"}\', 34: \'{"result":1.52}\', 35: \'{"result":"Undergraduate Studies"}\',
36: \'{"result":"5296"}\', 37: \'{"result":"6612"}\', 38: \'{"result":1311}\', 39: \'{"result":27}\'})'
<stdin>:2:Aborting import at record #28 (line 29). Previously-inserted values still
present.
28 rows imported in 0.325 seconds.

Please let me know what other information I can provide.

--
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