Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Inserting files into PRO_FILE table, How should I generate the File IDs

  1. #1

    Default Inserting files into PRO_FILE table, How should I generate the File IDs

    Hey Everyone,

    I am pretty new to Pentaho, and I am trying to insert some files into the pro_files table in my hsql db. I have easily found the schema and understand that the file_Id should be of varchar(100). I suppose any varchar would suffice, but it would be nice to have the same format that Pentaho has already. My log shows the following type of inserts and deletes

    INSERT INTO PRO_FILES VALUES('cd577153-ebd4-11e2-81c4-55d06efe89f5',0,'49c82592-d079-11e2-9fa5-cbb12043065f',....

    I am not too familiar with generating hashes or keys from file names, is anyone more familiar with this and able to tell me how to generate the id like 'cd577153-ebd4-11e2-81c4-55d06efe89f5'. Any help or links to documentation would be awesome. Thanks!

  2. #2

    Default

    So I figured out that these are UUID's, but when I try to generate UUID's from java for different files I cannot get them to match what the logs have. Any on idea on how the UUID's are seeded?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.