An Interactive Web UI for Approximate Query Processing

Built a UI for the YSU Data Lab to run database comparison tests

Check out my video presentation, using this passcode to watch: *e0E5a94

My slides are also available in this repository

capstone-project's People

Contributors

Watchers

capstone-project's Issues

SQL error

got the following error attempting to execute node 10MB_data_files/db_config.js

note: running MySQL 8.0.27 on MacOS 12.0.1

     throw err; // Rethrow non-MySQL errors
     ^

Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'customer.tbl INTO TABLE customer FIELDS TERMINATED BY '|'' at line 1
   at Query.Sequence._packetToError (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
   at Query.ErrorPacket (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
   at Protocol._parsePacket (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/Protocol.js:291:23)
   at Parser._parsePacket (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/Parser.js:433:10)
   at Parser.write (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/Parser.js:43:10)
   at Protocol.write (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/Protocol.js:38:16)
   at Socket.<anonymous> (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/Connection.js:88:28)
   at Socket.<anonymous> (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/Connection.js:526:10)
   at Socket.emit (node:events:390:28)
   at addChunk (node:internal/streams/readable:315:12)
   --------------------
   at Protocol._enqueue (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/Protocol.js:144:48)
   at Connection.query (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/Connection.js:198:25)
   at Handshake.<anonymous> (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/10MB_data_files/db_config.js:34:16)
   at Handshake.<anonymous> (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/Connection.js:526:10)
   at Handshake._callback (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/Connection.js:488:16)
   at Handshake.Sequence.end (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
   at Handshake.Sequence.OkPacket (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/sequences/Sequence.js:92:8)
   at Protocol._parsePacket (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/Protocol.js:291:23)
   at Parser._parsePacket (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/Parser.js:433:10)
   at Parser.write (/Users/ryan/OneDrive - Youngstown State University/GitHub/AQP-Website/node_modules/mysql/lib/protocol/Parser.js:43:10) {
 code: 'ER_PARSE_ERROR',
 errno: 1064,
 sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'customer.tbl INTO TABLE customer FIELDS TERMINATED BY '|'' at line 1",
 sqlState: '42000',
 index: 0,
 sql: "LOAD DATA LOCAL INFILE customer.tbl INTO TABLE customer FIELDS TERMINATED BY '|'"
}