How to write SortedSet of cassandra data type as json in python? -

-

i trying dump cassandra data in csv format using python. far, developed following script:

from cassandra.cluster import cluster cassandra.auth import plaintextauthprovider cassandra.query import tuple_factory cassandra.query import dict_factory import csv auth_provider = plaintextauthprovider(username='cassandra', password='std123') cluster = cluster(['127.0.0.1'],auth_provider=auth_provider) session = cluster.connect('killrvideo')  session.row_factory = tuple_factory rows = session.execute("select * videos videoid = 873ff430-9c23-4e60-be5f-278ea2bb21bd") row = cursor.fetchall() open('data.csv', 'w') fp:     = csv.writer(fp, delimiter=',')     a.writerows(rows)       cluster.shutdown()

and giving me output like:

873ff430-9c23-4e60-be5f-278ea2bb21bd, 2013-05-16 23:50:00, second in 3 part series cassandra data modeling, http://www.youtube.com/watch?v=qphhxujn5es,1, "sortedset([video_metadata(height=480, width=640, video_bit_rate=sortedset([u'1000kbs', u'400kbs']), encoding=u'mp4')])", become super modeler, {u'youtube': u'http://www.youtube.com/watch?v=qphhxujn5es'}, "sortedset([u'cassandra', u'cql', u'data model', u'instruction'])", 9761d3d7-7fbd-4269-9988-6cfd4e188678

i added new line manually can readable here. now, actual data set this:

 videoid            | 873ff430-9c23-4e60-be5f-278ea2bb21bd  added_date         | 2013-05-16 23:50:00.000000+0000  description        | second in 3 part series cassandra data modeling  location           | http://www.youtube.com/watch?v=qphhxujn5es  location_type      | 1  metadata           | {{height: 480, width: 640, video_bit_rate: {'1000kbs', '400kbs'}, encoding: 'mp4'}}  name               | become super modeler  preview_thumbnails | {'youtube': 'http://www.youtube.com/watch?v=qphhxujn5es'}  tags               | {'cassandra', 'cql', 'data model', 'instruction'}  userid             | 9761d3d7-7fbd-4269-9988-6cfd4e188678

my question in result set csv created value 

"sortedset([u'cassandra', u'cql', u'data model', u'instruction'])"

how can make simple json format use csv using copy command restore. here table description:

create table killrvideo.videos (     videoid uuid primary key,     added_date timestamp,     description text,     location text,     location_type int,     metadata set<frozen<video_metadata>>,     name text,     preview_thumbnails map<text, text>,     tags set<text>,     userid uuid )

please advise.

thanks.


Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more