Data getting overwritten with same timestamp in InfluxDB

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
0
down vote

favorite












There are some data in a csv file and it is getting overwritten if the timestamp is same, for example:



ip,time,name
1.1.1.1,2018-08-31 11:12:32,python
1.2.1.2,2018-08-31 11:05:28,oracle
1.3.1.3,2018-08-31 11:05:28,microsoft
1.4.2.5,2018-08-31 13:15:52,devops


The result in InfluxDB is coming as:



ip,time,name
1.1.1.1,2018-08-31 11:12:32,python
1.3.1.3,2018-08-31 11:05:28,microsoft
1.4.2.5,2018-08-31 13:15:52,devops


The issue is: The second-row record got overwritten by the third rows because the timestamp is same.



I want to insert all record in the InfluxDB.










share|improve this question























  • check.. this helps for your issue docs.influxdata.com/influxdb/v0.13/troubleshooting/…
    – Kamaraj
    Aug 31 at 7:57










  • Thanks, I have checked this link but can you tell me how I will make IP as unique value. In every file I am getting 98 records and every IP is unique. but what is the command to tell to InfluxDB to that the IP column is unique.
    – Syed Rizvi
    Aug 31 at 8:05














up vote
0
down vote

favorite












There are some data in a csv file and it is getting overwritten if the timestamp is same, for example:



ip,time,name
1.1.1.1,2018-08-31 11:12:32,python
1.2.1.2,2018-08-31 11:05:28,oracle
1.3.1.3,2018-08-31 11:05:28,microsoft
1.4.2.5,2018-08-31 13:15:52,devops


The result in InfluxDB is coming as:



ip,time,name
1.1.1.1,2018-08-31 11:12:32,python
1.3.1.3,2018-08-31 11:05:28,microsoft
1.4.2.5,2018-08-31 13:15:52,devops


The issue is: The second-row record got overwritten by the third rows because the timestamp is same.



I want to insert all record in the InfluxDB.










share|improve this question























  • check.. this helps for your issue docs.influxdata.com/influxdb/v0.13/troubleshooting/…
    – Kamaraj
    Aug 31 at 7:57










  • Thanks, I have checked this link but can you tell me how I will make IP as unique value. In every file I am getting 98 records and every IP is unique. but what is the command to tell to InfluxDB to that the IP column is unique.
    – Syed Rizvi
    Aug 31 at 8:05












up vote
0
down vote

favorite









up vote
0
down vote

favorite











There are some data in a csv file and it is getting overwritten if the timestamp is same, for example:



ip,time,name
1.1.1.1,2018-08-31 11:12:32,python
1.2.1.2,2018-08-31 11:05:28,oracle
1.3.1.3,2018-08-31 11:05:28,microsoft
1.4.2.5,2018-08-31 13:15:52,devops


The result in InfluxDB is coming as:



ip,time,name
1.1.1.1,2018-08-31 11:12:32,python
1.3.1.3,2018-08-31 11:05:28,microsoft
1.4.2.5,2018-08-31 13:15:52,devops


The issue is: The second-row record got overwritten by the third rows because the timestamp is same.



I want to insert all record in the InfluxDB.










share|improve this question















There are some data in a csv file and it is getting overwritten if the timestamp is same, for example:



ip,time,name
1.1.1.1,2018-08-31 11:12:32,python
1.2.1.2,2018-08-31 11:05:28,oracle
1.3.1.3,2018-08-31 11:05:28,microsoft
1.4.2.5,2018-08-31 13:15:52,devops


The result in InfluxDB is coming as:



ip,time,name
1.1.1.1,2018-08-31 11:12:32,python
1.3.1.3,2018-08-31 11:05:28,microsoft
1.4.2.5,2018-08-31 13:15:52,devops


The issue is: The second-row record got overwritten by the third rows because the timestamp is same.



I want to insert all record in the InfluxDB.







time database data load






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Sep 9 at 20:44









Rui F Ribeiro

36.8k1272117




36.8k1272117










asked Aug 31 at 7:54









Syed Rizvi

104




104











  • check.. this helps for your issue docs.influxdata.com/influxdb/v0.13/troubleshooting/…
    – Kamaraj
    Aug 31 at 7:57










  • Thanks, I have checked this link but can you tell me how I will make IP as unique value. In every file I am getting 98 records and every IP is unique. but what is the command to tell to InfluxDB to that the IP column is unique.
    – Syed Rizvi
    Aug 31 at 8:05
















  • check.. this helps for your issue docs.influxdata.com/influxdb/v0.13/troubleshooting/…
    – Kamaraj
    Aug 31 at 7:57










  • Thanks, I have checked this link but can you tell me how I will make IP as unique value. In every file I am getting 98 records and every IP is unique. but what is the command to tell to InfluxDB to that the IP column is unique.
    – Syed Rizvi
    Aug 31 at 8:05















check.. this helps for your issue docs.influxdata.com/influxdb/v0.13/troubleshooting/…
– Kamaraj
Aug 31 at 7:57




check.. this helps for your issue docs.influxdata.com/influxdb/v0.13/troubleshooting/…
– Kamaraj
Aug 31 at 7:57












Thanks, I have checked this link but can you tell me how I will make IP as unique value. In every file I am getting 98 records and every IP is unique. but what is the command to tell to InfluxDB to that the IP column is unique.
– Syed Rizvi
Aug 31 at 8:05




Thanks, I have checked this link but can you tell me how I will make IP as unique value. In every file I am getting 98 records and every IP is unique. but what is the command to tell to InfluxDB to that the IP column is unique.
– Syed Rizvi
Aug 31 at 8:05















active

oldest

votes











Your Answer







StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f465951%2fdata-getting-overwritten-with-same-timestamp-in-influxdb%23new-answer', 'question_page');

);

Post as a guest



































active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes















 

draft saved


draft discarded















































 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f465951%2fdata-getting-overwritten-with-same-timestamp-in-influxdb%23new-answer', 'question_page');

);

Post as a guest













































































Popular posts from this blog

How to check contact read email or not when send email to Individual?

Displaying single band from multi-band raster using QGIS

How many registers does an x86_64 CPU actually have?