Applying P Attribute to Disk

Community Support
1

Hi All,

I have a large table on disk and I’m trying to apply `p# attribute to specific date partitions.  I dont think I can use the 

addattrcol

in dbmaint.q, because the db is still loading and I dont want to appy the attribute to partitions that are still being loaded.

I tried

@[:db/2014.12.01/tab;sym;p#]`

but I’m getting 

ERROR: 'u-fail 

(invalid attempt to set “unique” attribute (list shouldn’t contain duplicate values before setting `u# attribute))

the table is sorted by symtime, just need to apply the attribute.  Any ideas what I’m doing wrong here?

Thanks

2

Is your data sorted on disk?

Try @[sym xasc :db/2014.12.01/tab;sym;p#]

3

I get the same error, also, I dont want to sort again really, because the table is sorted already and don’t want it to take longer

4

Hmmm… Not entirely sure then… 

It could be worth checking the enumeration of your sym column. It’s possible the underlying values might be out of whack.

HTH

5

Thanks,  I’m upsertting directly to disk using something like

(:/path/tab) upsert .Q.en[:c:/db] tab)

hopefully my sym file is ok, I should’nt be able to see syms though I dont think, if it was messed up

6

Yes I have `s attr on the sym col

I’m sorting on disk using this

``symtime xasc ( sv (:e:/path, $(string [d], “/tab”)));`

and then I’m compressing on disk using

-19!(( sv (:e:/path, $(string [d], “/tab”)));( sv (:e:/path, $(string [d], "/tab")));17;2;6);

does that look right?

7

I got sidetracked for a couple weeks :) but yes it actually looks like the data for the dates that I was trying to apply the attribute to was corrupted somehow.  It works now that Im trying on new data.  Thanks again for the help.