mikeizbicki / cmc-csci143

big data course materials
40 stars 76 forks source link

sql tests not passing #516

Closed myngpog closed 7 months ago

myngpog commented 7 months ago

hello! my sh load_tweets_parallel.sh runs properly and this is what my output looks like (or the gist of it)

2024-04-20 22:27:48.599279 insert_tweets i= 131
2024-04-20 22:27:49.189863 insert_tweets i= 132
2024-04-20 22:27:49.777282 insert_tweets i= 133
2024-04-20 22:27:53.240014 insert_tweets i= 134
2024-04-20 22:27:53.814122 insert_tweets i= 135
2024-04-20 22:27:54.337801 insert_tweets i= 136
2024-04-20 22:27:54.931673 insert_tweets i= 137
2024-04-20 22:27:55.522646 insert_tweets i= 138
2024-04-20 22:27:56.244855 insert_tweets i= 139
2024-04-20 22:27:56.993660 insert_tweets i= 140
2024-04-20 22:27:57.738669 insert_tweets i= 141

but when I run the normalized_batch command: time docker-compose exec pg_normalized_batch ./run_tests.sh sql.normalized_batch I get this;

sql.normalized_batch/01.sql pass
sql.normalized_batch/02.sql pass
sql.normalized_batch/03.sql pass
sql.normalized_batch/04.sql fail
sql.normalized_batch/05.sql pass

i had all the tests passing this morning but then I did step 0 and 1 again and now it doesn't work