Member since
01-17-2018
5
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
793 | 10-30-2019 09:37 AM |
10-30-2019
09:37 AM
I created a hack to solve this problem. In the ConvertJSONtoSQL processor I put table name = personal information. Notice the space. This generated the sql like so: insert into personal information <snipped> Then using a ReplaceTextProcessor I did a find and replace so such that the sql inserts were converted to the following: insert into `personal information` <snipped> This works but is very hacky...would love to see the correct way to get the back ticks to work
... View more
10-24-2019
09:34 AM
I'm using the ConvertJSONToSQL processor, and the MySql table has a space in the name. It appears to be the problem because when I remove the name from the table it works as expected.
I can successfully query the table from various tools and the mysql command line using back ticks "`" around the table name.
The table name: personal information
I've tried the following:
`personal information`
"personal information"
'personal information'
\"personal information\" [personal information]
Any suggestions?
... View more
Labels:
- Labels:
-
Apache NiFi
01-17-2018
05:41 PM
Here is an apache atlas hive column entity: {
"referredEntities": {
},
"entity": {
"typeName": "hive_column",
"attributes": {
"owner": null,
"qualifiedName": "make",
"name": "make",
"description": null,
"comment": null,
"position": 0,
"type": "make",
"table": {
"guid": "03fca616-ee26-4273-bf73-afb10fd1127c",
"typeName": "hive_table"
}
},
"guid": "d4ef03da-4659-4001-9597-02649a24e30b",
"status": "ACTIVE",
"createdBy": "admin",
"updatedBy": "admin",
"createTime": 1516120300604,
"updateTime": 1516132015809,
"version": 0,
"classifications": [
]
}
} The above JSON contains a version property which has the value of 0. I have changed the name property, qualifiedName property in the UI but the version value has remained 0. Can someone explain what causes that value to change and explain how versioning works in Apache Atlas?
... View more
Labels:
- Labels:
-
Apache Atlas