I created metadata over a "set" of files.
My next step is to define a primary over one of the files, and then foreign keys over the other files defined in my metadata relational database.
Unfortunately, when I attempt to define my primary key over the main file, I receive an SQL error message. I was able to determine that this is attributed to certain field names in the file beginning with special characters such as @, or $ which evidently SQL can not handle.
So, my question is, does anyone have a work around, or, do I need to rename all my fields in the relational database prior to creating the metadata?
Thank you for your feedback.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!