Hello, i have two non-time-overlapping measurements: > select * from swap order by time desc limit 3 name: swap time hostname metric service value ---- -------- ------ ------- ----- 1486117543000000000 LibSrv swap swap 8.380219392e+09 1486117543000000000 LibSrv total swap 8.387559424e+09 1486117485000000000 workstation02l total swap 4.09468928e+09
> select * from swappct order by time desc limit 3 name: swappct time hostname metric service value ---- -------- ------ ------- ----- 1486111789000000000 workstation02l total swap 4.09468928e+09 1486111789000000000 workstation02l swap swap 4.004511744e+09 1486111745000000000 LibSrv swap swap 8.380219392e+09 # and try to copy all in swappct to swap: >select * into swap from swappct which results in swap showing duplicate columns like hostname, hostname_1 etc. I even dropped the measurement swap, re-populated it from swappct and all columns were unique until the next measurement went in. - Why is that ? - How do i achieve my goal ? -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/a88a1d70-b63a-4423-ac3e-9245bd4d6f78%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.