title: How to use Distinct function in influxDB
body: <p>I am using influx DB and issuing command,</p>
  
  <pre><code>SELECT * FROM interface
  </code></pre>
  
  <p>Below is the out put-</p>
  
  <pre><code>interface 
  time                              element                path                                       value
  2016-08-24T21:22:16.7080877Z    "link-layer-address0"   "key:/arp-information/link-layer-address0"  "3c:61:04:48:df:91"
  2016-08-24T21:22:17.9090527Z    "link-layer-address0"   "key:/arp-information/link-layer-address0"  "3c:61:04:48:df:92"
  2016-08-24T21:22:19.8584133Z    "link-layer-address1"   "key:/arp-information/link-layer-address1"  "3c:61:04:48:df:97"
  2016-08-24T21:22:20.3377847Z    "link-layer-address2"   "key:/arp-information/link-layer-address2"  "3c:61:04:48:df:90"
  </code></pre>
  
  <p>When issue command it works fine. </p>
  
  <pre><code>SELECT distinct(value) FROM interface 
  </code></pre>
  
  <p>But When issue command for path column there is no out put. Wondering what i am missing?</p>
  
  <pre><code>SELECT distinct(path) FROM interface 
  </code></pre>