Re: Spark DataFrame Plotting

2016-09-08 Thread patcharee 

Hi Moon,

When I generate an extra column (schema will be Index:Int, A:Double, 
B:Double), what sql command to generate a graph with 2 lines (Index as a 
X-axis, BOTH A and B as Y-axis)? Do I need to group by?


Thanks!

Patcharee


On 07. sep. 2016 16:58, moon soo Lee wrote:
You will need to generate extra column which can be used as a X-axis 
for column A and B.


On Wed, Sep 7, 2016 at 2:34 AM Abhisar Mohapatra 
mailto:abhisar.mohapa...@inmobi.com>> 
wrote:


I am not sure ,But can you try once by grouby function in
zeppelin.If uou can group by columns then i guess that would do
the trick or pass the data to another HTML block and use d3
comparison chart to plot it

On Wed, Sep 7, 2016 at 2:56 PM, patcharee
mailto:patcharee.thong...@uni.no>> wrote:

Normal select * gives me one column on X-axis and another on
Y-axis. I cannot make both A:Double, B:Double displayed on
Y-axis. How to do that?

Patcharee


On 07. sep. 2016 11:05, Abhisar Mohapatra wrote:

You can do a normal select * on the dataframe and it would be
automatically interpreted.

On Wed, Sep 7, 2016 at 2:29 PM, patcharee
mailto:patcharee.thong...@uni.no>> wrote:

Hi,

I have a dataframe with this schema A:Double, B:Double.
How can I plot this dataframe as two lines (comparing A
and B at each step)?

Best,

Patcharee



_
The information contained in this communication is intended
solely for the use of the individual or entity to whom it is
addressed and others authorized to receive it. It may contain
confidential or legally privileged information. If you are
not the intended recipient you are hereby notified that any
disclosure, copying, distribution or taking any action in
reliance on the contents of this information is strictly
prohibited and may be unlawful. If you have received this
communication in error, please notify us immediately by
responding to this email and then delete it from your system.
The firm is neither liable for the proper and complete
transmission of the information contained in this
communication nor for any delay in its receipt. 




_
The information contained in this communication is intended solely
for the use of the individual or entity to whom it is addressed
and others authorized to receive it. It may contain confidential
or legally privileged information. If you are not the intended
recipient you are hereby notified that any disclosure, copying,
distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. If
you have received this communication in error, please notify us
immediately by responding to this email and then delete it from
your system. The firm is neither liable for the proper and
complete transmission of the information contained in this
communication nor for any delay in its receipt.

Re: Spark DataFrame Plotting

2016-09-07 Thread moon soo Lee 
You will need to generate extra column which can be used as a X-axis for
column A and B.

On Wed, Sep 7, 2016 at 2:34 AM Abhisar Mohapatra <
abhisar.mohapa...@inmobi.com> wrote:

> I am not sure ,But can you try once by grouby function in zeppelin.If uou
> can group by columns then i guess that would do the trick or pass the data
> to another HTML block and use d3 comparison chart to plot it
>
> On Wed, Sep 7, 2016 at 2:56 PM, patcharee 
> wrote:
>
>> Normal select * gives me one column on X-axis and another on Y-axis. I
>> cannot make both A:Double, B:Double displayed on Y-axis. How to do that?
>>
>> Patcharee
>>
>> On 07. sep. 2016 11:05, Abhisar Mohapatra wrote:
>>
>> You can do a normal select * on the dataframe and it would be
>> automatically interpreted.
>>
>> On Wed, Sep 7, 2016 at 2:29 PM, patcharee 
>> wrote:
>>
>>> Hi,
>>>
>>> I have a dataframe with this schema A:Double, B:Double. How can I plot
>>> this dataframe as two lines (comparing A and B at each step)?
>>>
>>> Best,
>>>
>>> Patcharee
>>>
>>>
>>
>> _
>> The information contained in this communication is intended solely for
>> the use of the individual or entity to whom it is addressed and others
>> authorized to receive it. It may contain confidential or legally privileged
>> information. If you are not the intended recipient you are hereby notified
>> that any disclosure, copying, distribution or taking any action in reliance
>> on the contents of this information is strictly prohibited and may be
>> unlawful. If you have received this communication in error, please notify
>> us immediately by responding to this email and then delete it from your
>> system. The firm is neither liable for the proper and complete transmission
>> of the information contained in this communication nor for any delay in its
>> receipt.
>>
>>
>>
>
> _
> The information contained in this communication is intended solely for the
> use of the individual or entity to whom it is addressed and others
> authorized to receive it. It may contain confidential or legally privileged
> information. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful. If you have received this communication in error, please notify
> us immediately by responding to this email and then delete it from your
> system. The firm is neither liable for the proper and complete transmission
> of the information contained in this communication nor for any delay in its
> receipt.

Re: Spark DataFrame Plotting

2016-09-07 Thread Abhisar Mohapatra 
I am not sure ,But can you try once by grouby function in zeppelin.If uou
can group by columns then i guess that would do the trick or pass the data
to another HTML block and use d3 comparison chart to plot it

On Wed, Sep 7, 2016 at 2:56 PM, patcharee  wrote:

> Normal select * gives me one column on X-axis and another on Y-axis. I
> cannot make both A:Double, B:Double displayed on Y-axis. How to do that?
>
> Patcharee
>
> On 07. sep. 2016 11:05, Abhisar Mohapatra wrote:
>
> You can do a normal select * on the dataframe and it would be
> automatically interpreted.
>
> On Wed, Sep 7, 2016 at 2:29 PM, patcharee 
> wrote:
>
>> Hi,
>>
>> I have a dataframe with this schema A:Double, B:Double. How can I plot
>> this dataframe as two lines (comparing A and B at each step)?
>>
>> Best,
>>
>> Patcharee
>>
>>
>
> _
> The information contained in this communication is intended solely for the
> use of the individual or entity to whom it is addressed and others
> authorized to receive it. It may contain confidential or legally privileged
> information. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful. If you have received this communication in error, please notify
> us immediately by responding to this email and then delete it from your
> system. The firm is neither liable for the proper and complete transmission
> of the information contained in this communication nor for any delay in its
> receipt.
>
>
>

-- 
_
The information contained in this communication is intended solely for the 
use of the individual or entity to whom it is addressed and others 
authorized to receive it. It may contain confidential or legally privileged 
information. If you are not the intended recipient you are hereby notified 
that any disclosure, copying, distribution or taking any action in reliance 
on the contents of this information is strictly prohibited and may be 
unlawful. If you have received this communication in error, please notify 
us immediately by responding to this email and then delete it from your 
system. The firm is neither liable for the proper and complete transmission 
of the information contained in this communication nor for any delay in its 
receipt.

Re: Spark DataFrame Plotting

2016-09-07 Thread patcharee 
Normal select * gives me one column on X-axis and another on Y-axis. I 
cannot make both A:Double, B:Double displayed on Y-axis. How to do that?


Patcharee


On 07. sep. 2016 11:05, Abhisar Mohapatra wrote:
You can do a normal select * on the dataframe and it would be 
automatically interpreted.


On Wed, Sep 7, 2016 at 2:29 PM, patcharee > wrote:


Hi,

I have a dataframe with this schema A:Double, B:Double. How can I
plot this dataframe as two lines (comparing A and B at each step)?

Best,

Patcharee



_
The information contained in this communication is intended solely for 
the use of the individual or entity to whom it is addressed and others 
authorized to receive it. It may contain confidential or legally 
privileged information. If you are not the intended recipient you are 
hereby notified that any disclosure, copying, distribution or taking 
any action in reliance on the contents of this information is strictly 
prohibited and may be unlawful. If you have received this 
communication in error, please notify us immediately by responding to 
this email and then delete it from your system. The firm is neither 
liable for the proper and complete transmission of the information 
contained in this communication nor for any delay in its receipt.

Re: Spark DataFrame Plotting

2016-09-07 Thread Abhisar Mohapatra 
You can do a normal select * on the dataframe and it would be automatically
interpreted.

On Wed, Sep 7, 2016 at 2:29 PM, patcharee  wrote:

> Hi,
>
> I have a dataframe with this schema A:Double, B:Double. How can I plot
> this dataframe as two lines (comparing A and B at each step)?
>
> Best,
>
> Patcharee
>
>

-- 
_
The information contained in this communication is intended solely for the 
use of the individual or entity to whom it is addressed and others 
authorized to receive it. It may contain confidential or legally privileged 
information. If you are not the intended recipient you are hereby notified 
that any disclosure, copying, distribution or taking any action in reliance 
on the contents of this information is strictly prohibited and may be 
unlawful. If you have received this communication in error, please notify 
us immediately by responding to this email and then delete it from your 
system. The firm is neither liable for the proper and complete transmission 
of the information contained in this communication nor for any delay in its 
receipt.

Spark DataFrame Plotting

2016-09-07 Thread patcharee 

Hi,

I have a dataframe with this schema A:Double, B:Double. How can I plot 
this dataframe as two lines (comparing A and B at each step)?


Best,

Patcharee