In the stored as parameter, you have specified the name of your dataset. The dataset name does not have to be specified there. Only the file format should be specified such as textfile. So, your command should be as below,
create table bought(number INT, price FLOAT, comments STRINGS)
row format delimited
fields terminated by','
lines terminated by '\n'
stored as textfile;