[
https://issues.apache.org/jira/browse/CASSANDRA-5991?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aleksey Yeschenko resolved CASSANDRA-5991.
------------------------------------------
Resolution: Won't Fix
The issue is one of your map values: {"result":27}. cassandra-dbapi2, the
library used by cqlsh, treats it as a pseudo-prepared statement bound param.
There is no easy fix for this, but the issue will go away once cqlsh is
switched to the native python-driver in 2.1.
> 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
> Assignee: Aleksey Yeschenko
>
> 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
