carissalow/rapids

1.3/features/phone-accelerometer/

Closed this issue · 3 comments

Qirtas commented

Hello, while fetching records from aware_sql container, RAPIDS is only fetching 5000 records from sql db to raw data file locally so I wanna ask is there any limit on the number of records?

JulioV commented

In general you are limited by the amount of RAM you have in your computer or cluster but when you hit that limit RAPIDS would stop.

From what you are describing RAPIDS is executing correctly but you are only seeing 5000 rows so it does not sound like a memory issue.

  1. Can you share the path of the file where you are seeing these 5k records?
  2. If you delete that file and re-execute RAPIDS you can actually see the SQL query RAPIDS executes (it's a SELECT * from accelerometer where device_id="asasds-bb...") Can you execute this query manually in MySQL workbench or Sequel Ace and check the number of rows returned?
Qirtas commented

Yes, the participant ID I was using had only 5k records in the DB. Thank you for your reply.

  • 👍1