how to use ascii character for quote in COPY in cqlsh

cassandra cql3 cqlsh csv sqlbulkcopy

Question

I'm using copy in cqlsh to transfer data from a large.csv file into Cassandra. I'm using CQL 3.0 and Cassandra 1.2. I must use another character to submit my data since " is a part of it; I must use any extended ASCII letters. I attempted a number of things but failed.

The following is functional, however for my needs I must use extended ASCII characters.

copy (<columnnames>) from <filename> where deleimiter='|' and quote = '"';
copy (<columnnames>) from <filename> where deleimiter='|' and quote = '~';

When I enter quote=", I get the following error:

:"quotechar" must be an 1-character string

Please provide me guidance on how to set the quotation parameter to utilize an expanded ASCII character.

I appreciate you.

1
0
7/18/2013 8:56:49 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I looked at the cqlsh script's source code since I was experiencing a similar issue. Finding the appropriate python csv settings was necessary in my situation since I was using Python to generate the csv.

Here is the important data from cqlsh:

    csv_dialect_defaults = dict(delimiter=',', doublequote=False,
                            escapechar='\\', quotechar='"')

It thus just requires using the csv module with: assuming you are fortunate enough to produce your.csv file using Python.

    writer = csv.writer(open("output.csv", 'w'), **csv_dialect_defaults)

Even if you are not using Python, I hope this helps.

0
9/12/2014 11:43:04 AM

Related Questions

Strings longer than 255 characters are not copied by SqlBulkCopy.

SqlBulkCopy and OldDbConnection are unfamiliar to me.... Excel may only be providing the first 255 characters, however.... When accessing a cell's value in Excel, the first 255 characters are returned if you use the.value property, and the whole text is returned if you use the.text property. I hope this helps you with your thinking.
excel sqlbulkcopy
asked by Adarsha

How to use SQL bulk copy to retrieve the IDs of added data records

I'm actively engaged in the following:...DataTable objects = new DataTable(); DataColumn keyColumn = new DataColumn("name", typeof(string)); DataColumn versionColumn = new DataColumn("version", typeof(int)); versionColumn.DefaultValue = iVersionID; objects.Columns.Add(keyColumn); objects.Columns.Add(versionColumn); foreach (KeyValuePair<string, N...
ado.net database identity sqlbulkcopy sql-server
asked by Timbo

Is it possible to transfer data across servers using sql bulk copy?

Yes. In reality, they copy to a table inside the same database in the example code seen in ...here....
sql sqlbulkcopy sql-server
asked by Joe Stefanelli

ASP.Net to MS-Access 2007 conversion (Bulk Insert, Bulk Copy)

Access 2007 can import XML natively. To generate the table definitions, you may import an XSD that you created for your specific data. From there, the XML should import correctly.
asp.net sqlbulkcopy vb.net xml
asked by Karelzarath

When SQLBulkCopy is used with Transaction, an event is fired each time a batch is copied.

Finally, I've chosen to use an internal transaction. As of right now, everything seems to be functioning well; if a mistake is made, the current batch is rolled back. Regarding Ben's earlier remark, I attempted what he suggested, but it isn't feasible since the code doesn't loop through a place where you may trigger an event. In the end, I raised m...
c# sqlbulkcopy sql-server
asked by Hans Rudel

Using file stream, sql bulk copy will not upload data to the database.

Simplify your code; there are several methods to import a csv file into a datatable (see, for instance, ....NET Datatable CSV file reading procedures...). You don't seem to be shutting the stream in your previous example when you have completed reading it, so add sr. Close() should be called before the return, or even better, use() should be used t...
asp.net c# sqlbulkcopy
asked by dash

"ERROR: extra data after last expected column" when using PostgreSQL COPY

A table that is empty won't do. You need a table with the same structure as the incoming data. the following...CREATE TABLE raw_data ( col1 int , col2 int ... ); ...There's no need to proclaim...tab... as ...DELIMITER... because that is the standard:...COPY raw_data FROM '/home/Projects/TestData/raw_data.txt'; ...What, 800 columns? That many c...
database-design dynamic-sql postgresql sqlbulkcopy
asked by Erwin Brandstetter

Using the SQL bulk copy in C# and deleting the string headers

Do this:...string format = "MM/dd/yyyy hh:mm:ss.fff"; DateTime d =DteTime.ParseExact(s[6],format,System.Globalization.CultureInfo.InvariantCulture); dr["DateTime"]=d; ...You may change the format to "MM/dd/yyyy" or "MM/dd/yyyy hh:mm," for example.
c# datetime sql sqlbulkcopy sql-server
asked by tHiNk_OuT_oF_bOx

Missing Data after insert into my end sql table using Sql Bulk Copy

You must examine the data in Access to identify and correct any incorrect column values, or you must deal with them in your TSQL after the export. Replace the temporary table with a real table, change the datetime datatype to string, export your data, and then query the database to locate the incorrect values so you know what sort of information to...
c# console-application datatable sqlbulkcopy sql-server-2008
asked by Greg

Using SQL Bulk Copy to insert ~3.7 million rows throws OutOfMemory exception

I appreciate all of your responses....I discovered the source of the issue. First of all, it didn't happen when I called SQL Bulk Copy, which I assumed might have been the case because, in a previous run, I was able to run a few thousand records fewer than I could now, leading me to believe that SQL Bulk Copy had restrictions or needed special sett...
c# sqlbulkcopy sql-server
asked by superachu

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow