0 votes
1 view
Hi,

I've tried this three different ways and it doesn't seem to want to let me upload a file to MyDB.

The file is a simple two-column CSV with a proper header and comma-separated values:
```
IRASPSC,TMASS_Designation
00254-3317,00275566-3300257
00428+6854,00460012+6910533
00439+1512,00463294+1528320
01037+1219,01062598+1235530
```

I first tried using the Data Explorer. When I try to upload the file, it says "Unable to process upload. Verify that the csv headers are present and that they match the table schema (for existing tables)". This wasn't an existing table, I just created a new name and started the upload.

I then tried using the command line, and after logging in and checking that I am logged in using `whoAmI`, I used `mydb_create` to create a schema and then tried to `mydb_insert` the table, but I get the response `schema "mydb" does not exist`.

Finally, I tried using the Jupyter notebook option online and retried the `mydb_create` and `mydb_insert`, and met with the same error (it says "OK" when I try `mydb_create`, and then fails to `insert`). The only thing I'm able to do with the notebook is to upload the table to VOSpace. However, when I try to copy it over from VOSpace to MyDB, I get the same error.
ago by sundarjhu (120 points) | 1 view

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

520 questions

526 answers

503 comments

695 users

Welcome to Data Lab Help Desk, where you can ask questions and receive answers from other members of the community.

Categories