# Re: how to deal with parted table?

**URL:** <https://forum.kx.com/t/re-how-to-deal-with-parted-table/5661>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [June 17, 2008, 1:08pm UTC](https://forum.kx.com/t/re-how-to-deal-with-parted-table/5661 "2008-06-17T13:08:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aaron\_Davies](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@Aaron\_Davies](https://forum.kx.com/u/Aaron_Davies)\
**Post date:** [June 17, 2008, 1:08pm UTC](https://forum.kx.com/t/re-how-to-deal-with-parted-table/5661/1 "2008-06-17T13:08:00Z")

</div>

alsoq)\l /path/to/table(or equivalently q)system"l /path/to/table")note that you can only have one table \l’d at a time in any given instance of qOn Tue, Jun 17, 2008 at 3:05 AM, Davies Liu \<davies.liu\> wrote:\> Hi,\>\> Another question: How to open the parted table in q scripts ?\>\> one way: put the scripts in the same directory with tables, then load q with\> the db path:\>\> # q /path/to/db\>\> Best regards,\> Davies Liu\>\> On Wed, Jun 4, 2008 at 2:18 PM, Davies \<davies.liu\> wrote:\>\>\>\> Hi, all:\>\>\>\> I create a parted table, just like in /kx/kdb+/taq/tq.q, the directory\>\> looks like:\>\>\>\> rohan/\>\> |-- 2008.05.08\>\> | `-- log&gt;&gt; | |-- agent&gt;&gt; | |-- bid&gt;&gt; | |-- code&gt;&gt; | |-- date&gt;&gt; | |-- ip&gt;&gt; | |-- length&gt;&gt; | |-- method&gt;&gt; | |-- nreferer&gt;&gt; | |-- nurl&gt;&gt; | |-- pt&gt;&gt; | |-- referer&gt;&gt; | |-- sid&gt;&gt; | |-- time&gt;&gt; | |-- uid&gt;&gt; | `– url\>\> |-- agent\>\> |-- sym\>\> `-- url&gt;&gt;&gt;&gt; then:&gt;&gt;&gt;&gt; # q rohan&gt;&gt; q) \v&gt;&gt; `agent`date`log`sym`url\>\> q)date\>\> ,2008.05.08\>\> q)type date\>\> 14h\>\> q)log\>\> log\>\> q)type log\>\> 101h / what does 101h mean?\>\> q)select from log\>\> 'type\>\> q)count value `:2008.05.08/log/\>\> 10\>\>\>\> how to deal with the parted table log, especially cross dates?\>\>\>\> Best Regards,\>\> Davies Liu\>\>\>\>\> \>\>– Aaron [Daviesaaron.davies@gmail.com](mailto:Daviesaaron.davies@gmail.com)\</davies.liu\>\</davies.liu\>