Advanced capstone 2.2

Academy Support
1

https://learninghub.kx.com/forums/topic/advanced-capstone-2-2

Does anyone know why my code won't pass it fully it fails the "contain all columns for 2nd Jan 2020" section of the test for 2.2.

lapTable: select date: 2020.01.02, sensorId, session, lapId, time, endTime, sensorValue from lap

thats my code for 2.2

2

Hi @timbs_1995

It states in the exercise that you must load the lap table from disk.

To do we use the system command:

\l

**Tip: Instead of listing each individual column, you can simply run 

select from lap

To retrieve the entire lap table.

Hope this helps!

Thanks,

Megan

3

when i go use the system command like so

\l lapTable: select date,sensorId, session, lapId, time, endTime, sensorValue from lap where date = 2020.01.02

it says its not implemented

4

Hi @timbs_1995

Sorry my mistake - you must add the name of the directory.

Which in this case is f1:

\l f1

Thanks,

Megan

5

I'm getting the same error

6

Hi @timbs_1995

The \l f1 command simply loads in the lap data from disk.

You must then preform your select statement for lapTable.

Thanks,

Megan

7

Why does it say theres no such file or directory?

8

Does it pass the tests anyway?

9

No it fails all of the 2.2 sections test