Thanks Nihal! This is how I tried it, but I am trying to pull my json file from a URL, so I can't do (s"http://ip.json"). If you know any easy fix to this (other than saving the file), please let me know, if not no worries, as I'm also going to have this data in hdfs/hive.
the code i tried was: val url = new URL("http://rest.json") val content = fromInputStream(url.openStream).getLines.mkString("\n") val x = sqlContext.jsonFile(content) On Mon, Jun 29, 2015 at 9:53 PM, Nihal Bhagchandani < nihal_bhagchand...@yahoo.com> wrote: > Hi Su, > > following is the code which I have used to access JSON file in zeppelin > > //load tweets Json Data as DataFrame > val jfile = > sqlContext.jsonFile(s"file:///local/path/on/my/machine/data.json") > > //print the schema for jFile DataFrame > jfile.printSchema > > //since jfile holds the data in DataFrames we can directly register this > data as table > jfile.registerTempTable("jTable") > > hope this helps... > > Nihal > > > > On Tuesday, 30 June 2015 12:50 AM, Su She <suhsheka...@gmail.com> wrote: > > > Hello Nihal, > > Quick question, how were you able to read data from a Json file? I've been > unable to import "play.api.libs.json". > > Thanks! > > Best, > > Su > > On Fri, Jun 26, 2015 at 9:00 AM, Nihal Bhagchandani < > nihal_bhagchand...@yahoo.com> wrote: > > Sure, I am just waiting for my zeppelinhub.com credentials. > This whole data come from 2 files. > 1. CSV file where I kept all the session related data. > 2. Json file where I kept all the sentiments related data for each > session, we collected the live tweets and calculated the sentiments. > After the whole event ends we transfer the data from mongodb to this json > file. > > I have used zeppelin to show sentiments of each session along with the > word cloud of hash tags participants used during that session. > > Kevin: please let me know which part you are keen on I would try to help > for sure. > > Thanks once again for the support moon and all the zeppelin team you guys > rock...! > > -Nihal > > Sent from my iPhone > > On 26-Jun-2015, at 20:48, moon soo Lee <m...@apache.org> wrote: > > Wow! > Thanks for sharing the screen! > > Best, > moon > > > On Fri, Jun 26, 2015 at 8:06 AM Kevin (Sangwoo) Kim <kevin...@apache.org> > wrote: > > Geat job!! > > could you share some codes you've working on too?? > > > 2015년 6월 26일 (금) 오후 6:54, Nihal Bhagchandani <nihal_bhagchand...@yahoo.com>님이 > 작성: > > Hi Team, > > thanks for working on this awesome tool... > I have been using this tool since last 2 weeks or so... > attached is the visualization which I able to achieved so far... > > Nihal > > > > > >