I am getting following error while loading data from C drive,
The same command works fine if i keep data and jupyter notebook on D drive.
I have also tried to run as administrator but it still fails.
Need to understand following error to troubleshoot.
---------------------------------------------------------------------------errorTraceback (most recent call last)\<ipython-input-3-062bdf9de0f4\>in\<module\>() 1----\> 2 get_ipython().run_line_magic('q','\\l /db/mdata') 3get_ipython().run_line_magic('q','count select from quote where date=2018.07.02')C:\pye\venv\Lib\site-packages\IPython\core\interactiveshell.pyinrun\_line\_magic(self, magic\_name, line, \_stack\_depth) 2129kwargs['local\_ns']=sys._getframe(stack_depth).f_locals 2130withself.builtin_trap:-\> 2131result=fn(\*args,\*\*kwargs) 2132returnresult 2133C:\pye\venv\Lib\site-packages\pyq\magic.pyinq(line, cell, \_ns) 58""" 59ifcellisNone:---\> 60returnpyq.q(line) 61 62if_nsisNone:C:\pye\venv\Lib\site-packages\pyq\_\_init\_\_.pyin\_\_call\_\_(self, m, \*args) 651"""Execute q code.""" 652try:--\> 653returnK._k(0,m,\*map(K,args)) 654exceptTypeError: 655ifmisnotNone:error: desktop.ini
Remove desktop.ini from /db/mdata
Thanks Flying, its works after removing desktop.ini file.
I understand that KDB loads everything from by \l command.
It recognized every this owned by q.
KDB should just ignore that is not recognized as q rather throwing error.
Another way to think of it: The directory that you explicitly want q to load should follow the directory structure dictated by the manual. So if you are putting anything extra there, it breaks the system. This is just what “configuration by convention” means.
Another similar issue often happens on MacOS because of .DS_Store files created by Finder.