title: InfluxDB Regular Expression
body: <p>All</p>
  
  <p>I have database named <code>fenetto_data</code> in <code>influxdb</code>. In that I have a table named <code>metrics</code> that have following fields</p>
  
  <ul>
  <li>volt  </li>
  <li>humidity    </li>
  <li>watt</li>
  </ul>
  
  <p>for example I'm creating retention policy on database <code>fernetto_data</code></p>
  
  <pre><code>create retention policy "rp_14days" on "fernetto_data" duration 14d     replication 1 shard duration 1d
  </code></pre>
  
  <p>by using this retention policy I'm creating continuous query</p>
  
  <p>-></p>
  
  <pre><code>create continuous query "cq_5m_rollups" on "fernetto_data" 
        resample for 14d
        begin
            select mean(/./) into "rp_14days"."metrics.5m" from "metrics" group by time(5m)
        end
  </code></pre>
  
  <p>this will create new table named <code>metrics.5m</code></p>
  
  <p>and this is storing fields of the form </p>
  
  <ul>
  <li>mean_volt    </li>
  <li>mean_humidity </li>
  <li>mean_watt</li>
  </ul>
  
  <p>but my requirement is <code>metrics.5m</code> is also need to store field name same as metrics</p>
  
  <p>Is this possible?</p>
  
  <p>Thanks in advance!</p>