Can we have HDB table without sym column?

Community Support
1

Hi, I’ve created few new table in the RDB, without sym columns, and that working fine.

However, after it archive to HDB, and I just run “select from table where date=xxx” , there is error saying that “folder/sym file” is missing, is that a sym column is mandatory for all HDB?

2

Your hdb is probably missing the sym file=FD. Is there a sym variable defin= ed? key:sym sym in key. How did you save the tables? If you used .Q.en[:.] kdb probably made the s= ym file in the rdb root not the hdb root. You’d have to use .Q.en[`:hdbroot=] instead. If none of your tables have symbol columns, you could create an empty sym f= ile and try again. From: Carfield Yim Sent: Tuesday, July 5, 2016 03:32 To: Kdb+ Personal Developers Reply To: personal-kdbplus@googlegroups.com Subject: [personal kdb+] Can we have HDB table without sym column? Hi, I’ve created few new table in the RDB, without sym columns, and that wo= rking fine. However, after it archive to HDB, and I just run “select from table where d= ate=3Dxxx” , there is error saying that “folder/sym file” is missing, is th= at a sym column is mandatory for all HDB? – Submitted via Google Groups

3

Thanks David, I use .Q.dpft 

4

Sorry, please ignore, it is just I default to use sym as&nbsp;;<tt>p#field if that is not specified