• KX Academy

  Problem with fundamentals capstone Data Analytics and Reporting,

  Posted by Juanse on December 18, 2024 at 7:43 pm

  Hi i loaded the db with this command 

  system “l “,getenv[`HOME],”/fundamentals_capstone_dbs/2020.08.06”  </p><p><br></p><p><br></p><p>because i had problems loading it normal: </p><p><br></p><p>system “l “,getenv[`HOME],”/fundamentals_capstone_dbs/”

   returns: part

  i tried to:  select from trade where date=last date , returns : date

  the table trade doesnt have date i assume because i loaded from a date file , i need to load the db on the normal way

  • This discussion was modified 3 days, 6 hours ago by  Juanse.
  • This discussion was modified 3 days, 6 hours ago by  Juanse.

  mwoods replied 2 days, 15 hours ago 2 Members · 1 Reply
• 1 Reply

• 

  mwoods

  Administrator

  December 19, 2024 at 11:18 am

  Hi Juanse, part indicates something is off with your directory structure. I logged into your environment as admin and using ls could check there was indeed an erroneous file “5457”. I removed this file and was able to load the database.

  This should work for you now, trade should be available to query

  Thanks,

  Michaela 

  

Log In to Reply