<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Unable to subset the data using SparkR, using piping convention to execute the commands in Data Engineering</title>
    <link>https://community.databricks.com/t5/data-engineering/unable-to-subset-the-data-using-sparkr-using-piping-convention/m-p/17318#M11345</link>
    <description>&lt;P&gt;&lt;/P&gt;
&lt;P&gt;I'm operating on some data that looks like the image attached.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0693f000007OoRwAAK"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/2458i9079B5F28E5A9E08/image-size/large?v=v2&amp;amp;px=999" role="button" title="0693f000007OoRwAAK" alt="0693f000007OoRwAAK" /&gt;&lt;/span&gt;the command that I'm performing is :&lt;/P&gt;&amp;lt;code&amp;gt;library(magrittr)
&lt;P&gt;&lt;/P&gt; 
&lt;B&gt;subsetting the data for MAC-OS &amp;amp; sorting by event-timestamp.&lt;/B&gt; 
&lt;P&gt;acDF &amp;lt;- eventsDF %&amp;gt;% SparkR::select("device", "event_timestamp") SparkR::filter("device = macOS") %&amp;gt;% SparkR::arrange("event_timestamp") display(macDF) &amp;lt;/code&amp;gt; &lt;/P&gt;
&lt;PRE&gt;&lt;CODE&gt; &lt;/CODE&gt;&lt;/PRE&gt; 
&lt;PRE&gt;&lt;CODE&gt;&amp;lt;br&amp;gt;&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;And the error I get is:&lt;/P&gt;
&lt;PRE&gt;&lt;CODE&gt;&amp;lt;code&amp;gt;Error in h(simpleError(msg, call)) : 
  error in evaluating the argument 'x' in selecting a method for function 'arrange': unable to find an inherited method for function ‘filter’ for signature ‘"character", "missing"’
Some(&amp;lt;code style = 'font-size:10p'&amp;gt; Error in h(simpleError(msg, call)): error in evaluating the argument 'x' in selecting a method for function 'arrange': unable to find an inherited method for function ‘filter’ for signature ‘"character", "missing"’ &amp;lt;/code&amp;gt;)&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;Any leads on where the mistake is would be highly appreciated, I'm unable to find out what am I missing on from the error code.&lt;/P&gt; 
&lt;P&gt;&lt;/P&gt;</description>
    <pubDate>Mon, 26 Jul 2021 12:59:41 GMT</pubDate>
    <dc:creator>RiyazAliM</dc:creator>
    <dc:date>2021-07-26T12:59:41Z</dc:date>
    <item>
      <title>Unable to subset the data using SparkR, using piping convention to execute the commands</title>
      <link>https://community.databricks.com/t5/data-engineering/unable-to-subset-the-data-using-sparkr-using-piping-convention/m-p/17318#M11345</link>
      <description>&lt;P&gt;&lt;/P&gt;
&lt;P&gt;I'm operating on some data that looks like the image attached.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0693f000007OoRwAAK"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/2458i9079B5F28E5A9E08/image-size/large?v=v2&amp;amp;px=999" role="button" title="0693f000007OoRwAAK" alt="0693f000007OoRwAAK" /&gt;&lt;/span&gt;the command that I'm performing is :&lt;/P&gt;&amp;lt;code&amp;gt;library(magrittr)
&lt;P&gt;&lt;/P&gt; 
&lt;B&gt;subsetting the data for MAC-OS &amp;amp; sorting by event-timestamp.&lt;/B&gt; 
&lt;P&gt;acDF &amp;lt;- eventsDF %&amp;gt;% SparkR::select("device", "event_timestamp") SparkR::filter("device = macOS") %&amp;gt;% SparkR::arrange("event_timestamp") display(macDF) &amp;lt;/code&amp;gt; &lt;/P&gt;
&lt;PRE&gt;&lt;CODE&gt; &lt;/CODE&gt;&lt;/PRE&gt; 
&lt;PRE&gt;&lt;CODE&gt;&amp;lt;br&amp;gt;&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;And the error I get is:&lt;/P&gt;
&lt;PRE&gt;&lt;CODE&gt;&amp;lt;code&amp;gt;Error in h(simpleError(msg, call)) : 
  error in evaluating the argument 'x' in selecting a method for function 'arrange': unable to find an inherited method for function ‘filter’ for signature ‘"character", "missing"’
Some(&amp;lt;code style = 'font-size:10p'&amp;gt; Error in h(simpleError(msg, call)): error in evaluating the argument 'x' in selecting a method for function 'arrange': unable to find an inherited method for function ‘filter’ for signature ‘"character", "missing"’ &amp;lt;/code&amp;gt;)&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;Any leads on where the mistake is would be highly appreciated, I'm unable to find out what am I missing on from the error code.&lt;/P&gt; 
&lt;P&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 26 Jul 2021 12:59:41 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/unable-to-subset-the-data-using-sparkr-using-piping-convention/m-p/17318#M11345</guid>
      <dc:creator>RiyazAliM</dc:creator>
      <dc:date>2021-07-26T12:59:41Z</dc:date>
    </item>
  </channel>
</rss>

