timestamp problem once loaded the field are 0000-00-00 00:00:00MariaDB SQL performance issue with indexMariaDB LOAD DATA INFILE csv file not reading correctlyDifference in datafile size on a same data?mariaDB JSON support in LaravelCreating tables error and create multiple tables using codeigniterSQL Syntax Error - Can't Importhow to echo a retrieved default value from a database columnvoyager databases and MariaDB serverMysql Load File Error loading inaccurate dataSymfony 4 after generating user via make:user schema update crashed
Decision Variable Value from a Set (Gurobi)
Did the Soviet army intentionally send troops (e.g. penal battalions) running over minefields?
Sending mail to the Professor for PhD, after seeing his tweet
Why does `FindFit` fail so badly in this simple case?
Short story about a potato hotel that makes its guests into potatoes throughout the night
Where does the image of a data connector as a sharp metal spike originate from?
Airport Security - advanced check, 4th amendment breach
French license plates
GPLv3 forces us to make code available, but to who?
Does Bank Manager's discretion still exist in Mortgage Lending
When Vesuvan Shapeshifter copies turn face up replacement effects, why do they work?
How dangerous is a very out-of-true disc brake wheel?
Would a horse be sufficient buffer to prevent injury when falling from a great height?
Why does it seem the best way to make a living is to invest in real estate?
Is there a way to remove Smite from a weapon?
How to find places to store/land a private airplane?
Isn't the detector always measuring, and thus always collapsing the state?
Disable all sound permanently
Can I cast Death Ward on additional creatures without causing previous castings to end?
Should I be an author on another PhD student's paper if I went to their meetings and gave advice?
A word that refers to saying something in an attempt to anger or embarrass someone into doing something that they don’t want to do?
How is this situation not a checkmate?
What is the difference between increasing volume and increasing gain?
Could the Queen overturn the UK Supreme Court ruling regarding prorogation of Parliament?
timestamp problem once loaded the field are 0000-00-00 00:00:00
MariaDB SQL performance issue with indexMariaDB LOAD DATA INFILE csv file not reading correctlyDifference in datafile size on a same data?mariaDB JSON support in LaravelCreating tables error and create multiple tables using codeigniterSQL Syntax Error - Can't Importhow to echo a retrieved default value from a database columnvoyager databases and MariaDB serverMysql Load File Error loading inaccurate dataSymfony 4 after generating user via make:user schema update crashed
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;
my CSV file is
dc,HostID,HostMBReads,HostMBWrites,Reads,Writes,MBs,ReadResponseTime,WriteResponseTime,ResponseTime,SyscallCount,HostIOs,time
300000000252,lac01_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.38602328,0.0,2019-03-27 18:50:00
300000000252,lac03_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.81333333,0.0,2019-03-27 18:55:00
300000000252,lac04_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.40666667,0.0,2019-03-27 19:00:00
300000000252,lac05_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.4342762,0.0,2019-03-27 19:05:00
300000000252,solace_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 18:50:00
300000000252,solace1_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 18:55:00
300000000252,solace2_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 19:00:00
300000000252,solace3_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 19:05:00
i created the table with this :
CREATE TABLE `host_metrics` (
`dc` VARCHAR(255) NOT NULL DEFAULT '',
`HostID` VARCHAR(255) NOT NULL DEFAULT '',
`HostMBReads` DOUBLE NOT NULL DEFAULT '0.00000000',
`HostMBWrites` DOUBLE NOT NULL DEFAULT '0.00000000',
`Reads` DOUBLE NOT NULL DEFAULT '0.00000000',
`Writes` DOUBLE NOT NULL DEFAULT '0.00000000',
`MBs` DOUBLE NOT NULL DEFAULT '0.00000000',
`ReadResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`WriteResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`ResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`SyscallCount` DOUBLE NOT NULL DEFAULT '0.00000000',
`HostIOs` DOUBLE NOT NULL DEFAULT '0.00000000',
`time` TIMESTAMP NOT NULL,
PRIMARY KEY (dc,HostID,time));
i load the data with this
LOAD DATA LOCAL INFILE '/home/max/GLOBAL_Host_metrics.csv' INTO TABLE host_metrics FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n' IGNORE 1 ROWS (dc, HostID, HostMBReads, HostMBWrites, `Reads`, Writes, MBs, ReadResponseTime, ResponseTime, SyscallCount, HostIOs, time);
the problem the select show me the time at 0000-00-00 00:00:00 for all the hosts
mariadb
edited May 8 at 11:57
Rick James
80k5 gold badges71 silver badges113 bronze badges
asked Mar 28 at 20:45
MaxMax
155 bronze badges
add a comment
|
my CSV file is
dc,HostID,HostMBReads,HostMBWrites,Reads,Writes,MBs,ReadResponseTime,WriteResponseTime,ResponseTime,SyscallCount,HostIOs,time
300000000252,lac01_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.38602328,0.0,2019-03-27 18:50:00
300000000252,lac03_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.81333333,0.0,2019-03-27 18:55:00
300000000252,lac04_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.40666667,0.0,2019-03-27 19:00:00
300000000252,lac05_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.4342762,0.0,2019-03-27 19:05:00
300000000252,solace_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 18:50:00
300000000252,solace1_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 18:55:00
300000000252,solace2_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 19:00:00
300000000252,solace3_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 19:05:00
i created the table with this :
CREATE TABLE `host_metrics` (
`dc` VARCHAR(255) NOT NULL DEFAULT '',
`HostID` VARCHAR(255) NOT NULL DEFAULT '',
`HostMBReads` DOUBLE NOT NULL DEFAULT '0.00000000',
`HostMBWrites` DOUBLE NOT NULL DEFAULT '0.00000000',
`Reads` DOUBLE NOT NULL DEFAULT '0.00000000',
`Writes` DOUBLE NOT NULL DEFAULT '0.00000000',
`MBs` DOUBLE NOT NULL DEFAULT '0.00000000',
`ReadResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`WriteResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`ResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`SyscallCount` DOUBLE NOT NULL DEFAULT '0.00000000',
`HostIOs` DOUBLE NOT NULL DEFAULT '0.00000000',
`time` TIMESTAMP NOT NULL,
PRIMARY KEY (dc,HostID,time));
i load the data with this
LOAD DATA LOCAL INFILE '/home/max/GLOBAL_Host_metrics.csv' INTO TABLE host_metrics FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n' IGNORE 1 ROWS (dc, HostID, HostMBReads, HostMBWrites, `Reads`, Writes, MBs, ReadResponseTime, ResponseTime, SyscallCount, HostIOs, time);
the problem the select show me the time at 0000-00-00 00:00:00 for all the hosts
mariadb
edited May 8 at 11:57
Rick James
80k5 gold badges71 silver badges113 bronze badges
asked Mar 28 at 20:45
MaxMax
155 bronze badges
add a comment
|
my CSV file is
dc,HostID,HostMBReads,HostMBWrites,Reads,Writes,MBs,ReadResponseTime,WriteResponseTime,ResponseTime,SyscallCount,HostIOs,time
300000000252,lac01_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.38602328,0.0,2019-03-27 18:50:00
300000000252,lac03_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.81333333,0.0,2019-03-27 18:55:00
300000000252,lac04_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.40666667,0.0,2019-03-27 19:00:00
300000000252,lac05_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.4342762,0.0,2019-03-27 19:05:00
300000000252,solace_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 18:50:00
300000000252,solace1_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 18:55:00
300000000252,solace2_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 19:00:00
300000000252,solace3_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 19:05:00
i created the table with this :
CREATE TABLE `host_metrics` (
`dc` VARCHAR(255) NOT NULL DEFAULT '',
`HostID` VARCHAR(255) NOT NULL DEFAULT '',
`HostMBReads` DOUBLE NOT NULL DEFAULT '0.00000000',
`HostMBWrites` DOUBLE NOT NULL DEFAULT '0.00000000',
`Reads` DOUBLE NOT NULL DEFAULT '0.00000000',
`Writes` DOUBLE NOT NULL DEFAULT '0.00000000',
`MBs` DOUBLE NOT NULL DEFAULT '0.00000000',
`ReadResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`WriteResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`ResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`SyscallCount` DOUBLE NOT NULL DEFAULT '0.00000000',
`HostIOs` DOUBLE NOT NULL DEFAULT '0.00000000',
`time` TIMESTAMP NOT NULL,
PRIMARY KEY (dc,HostID,time));
i load the data with this
LOAD DATA LOCAL INFILE '/home/max/GLOBAL_Host_metrics.csv' INTO TABLE host_metrics FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n' IGNORE 1 ROWS (dc, HostID, HostMBReads, HostMBWrites, `Reads`, Writes, MBs, ReadResponseTime, ResponseTime, SyscallCount, HostIOs, time);
the problem the select show me the time at 0000-00-00 00:00:00 for all the hosts
mariadb
edited May 8 at 11:57
Rick James
80k5 gold badges71 silver badges113 bronze badges
asked Mar 28 at 20:45
MaxMax
155 bronze badges
my CSV file is
dc,HostID,HostMBReads,HostMBWrites,Reads,Writes,MBs,ReadResponseTime,WriteResponseTime,ResponseTime,SyscallCount,HostIOs,time
300000000252,lac01_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.38602328,0.0,2019-03-27 18:50:00
300000000252,lac03_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.81333333,0.0,2019-03-27 18:55:00
300000000252,lac04_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.40666667,0.0,2019-03-27 19:00:00
300000000252,lac05_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.4342762,0.0,2019-03-27 19:05:00
300000000252,solace_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 18:50:00
300000000252,solace1_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 18:55:00
300000000252,solace2_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 19:00:00
300000000252,solace3_ig,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2019-03-27 19:05:00
i created the table with this :
CREATE TABLE `host_metrics` (
`dc` VARCHAR(255) NOT NULL DEFAULT '',
`HostID` VARCHAR(255) NOT NULL DEFAULT '',
`HostMBReads` DOUBLE NOT NULL DEFAULT '0.00000000',
`HostMBWrites` DOUBLE NOT NULL DEFAULT '0.00000000',
`Reads` DOUBLE NOT NULL DEFAULT '0.00000000',
`Writes` DOUBLE NOT NULL DEFAULT '0.00000000',
`MBs` DOUBLE NOT NULL DEFAULT '0.00000000',
`ReadResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`WriteResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`ResponseTime` DOUBLE NOT NULL DEFAULT '0.00000000',
`SyscallCount` DOUBLE NOT NULL DEFAULT '0.00000000',
`HostIOs` DOUBLE NOT NULL DEFAULT '0.00000000',
`time` TIMESTAMP NOT NULL,
PRIMARY KEY (dc,HostID,time));
i load the data with this
LOAD DATA LOCAL INFILE '/home/max/GLOBAL_Host_metrics.csv' INTO TABLE host_metrics FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n' IGNORE 1 ROWS (dc, HostID, HostMBReads, HostMBWrites, `Reads`, Writes, MBs, ReadResponseTime, ResponseTime, SyscallCount, HostIOs, time);
the problem the select show me the time at 0000-00-00 00:00:00 for all the hosts
mariadb
mariadb
edited May 8 at 11:57
Rick James
80k5 gold badges71 silver badges113 bronze badges
asked Mar 28 at 20:45
MaxMax
155 bronze badges
edited May 8 at 11:57
Rick James
80k5 gold badges71 silver badges113 bronze badges
asked Mar 28 at 20:45
MaxMax
155 bronze badges
edited May 8 at 11:57
Rick James
80k5 gold badges71 silver badges113 bronze badges
edited May 8 at 11:57
Rick James
80k5 gold badges71 silver badges113 bronze badges
edited May 8 at 11:57
Rick James
80k5 gold badges71 silver badges113 bronze badges
80k5 gold badges71 silver badges113 bronze badges
asked Mar 28 at 20:45
MaxMax
155 bronze badges
asked Mar 28 at 20:45
MaxMax
155 bronze badges
asked Mar 28 at 20:45
MaxMax
155 bronze badges
155 bronze badges
add a comment
|
add a comment
|
1 Answer
1
active
oldest
votes
You have an extra column in the data, or a missing column name from the list.
answered May 8 at 12:12
Rick JamesRick James
80k5 gold badges71 silver badges113 bronze badges
add a comment
|
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55406586%2ftimestamp-problem-once-loaded-the-field-are-0000-00-00-000000%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You have an extra column in the data, or a missing column name from the list.
answered May 8 at 12:12
Rick JamesRick James
80k5 gold badges71 silver badges113 bronze badges
add a comment
|
You have an extra column in the data, or a missing column name from the list.
answered May 8 at 12:12
Rick JamesRick James
80k5 gold badges71 silver badges113 bronze badges
add a comment
|
You have an extra column in the data, or a missing column name from the list.
answered May 8 at 12:12
Rick JamesRick James
80k5 gold badges71 silver badges113 bronze badges
You have an extra column in the data, or a missing column name from the list.
answered May 8 at 12:12
Rick JamesRick James
80k5 gold badges71 silver badges113 bronze badges
answered May 8 at 12:12
Rick JamesRick James
80k5 gold badges71 silver badges113 bronze badges
answered May 8 at 12:12
Rick JamesRick James
80k5 gold badges71 silver badges113 bronze badges
answered May 8 at 12:12
Rick JamesRick James
80k5 gold badges71 silver badges113 bronze badges
80k5 gold badges71 silver badges113 bronze badges
add a comment
|
add a comment
|
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55406586%2ftimestamp-problem-once-loaded-the-field-are-0000-00-00-000000%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
