Home › Forums › PyKX › kx.q.sql(‘select * from trades’) command error › Re: kx.q.sql(‘select * from trades’) command error
-
>>> kx.q(‘trades: ([]sym:`ibm`msft`apple`samsung;mcap:2000 4000 9000 6000;ex:`nasdaq`nasdaq`DAX`Dow)’)pykx.Identity(pykx.q(‘::’)) >>> kx.q.sql(‘select * from trades’)Traceback (most recent call last):File “”, line 1, in File “/opt/anaconda3/envs/shift/lib/python3.11/site-packages/pykx/query.py”, line 528, in __call__return self._q(‘.s.sp’, k.CharVector(query), args)^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^File “/opt/anaconda3/envs/shift/lib/python3.11/site-packages/pykx/embedded_q.py”, line 142, in __call__return factory(result, False)^^^^^^^^^^^^^^^^^^^^^^File “pykx/_wrappers.pyx”, line 499, in pykx._wrappers._factoryFile “pykx/_wrappers.pyx”, line 492, in pykx._wrappers.factorypykx.exceptions.QError: .s.sp >>> pykx.q(‘l s.k_’)pykx.Identity(pykx.q(‘::’))>>> kx.q.sql(‘select * from trades’)pykx.Table(pykx.q(‘sym mcap ex——————-ibm 2000 nasdaqmsft 4000 nasdaqapple 9000 DAXsamsung 6000 Dow’)) Do I need to add “pykx.q(‘l s.k_’)” command before every kx.q.sql query?