You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@atlas.apache.org by doom <43...@qq.com> on 2017/12/11 09:44:44 UTC

why quick_start.py error and how to clear all the data.

hi all.

I use the git embedded-hbase-solr version.




when run quick_start.py it throws exception, how to fix it.

and after the exception, i re-run the quick_start.py, will 

failed with status 409 (Conflict) Response Body ({"errorCode":"ATLAS-409-00-001","errorMessage":"Given type Dimension already exists"})

how to clear all the data.
 






FynndeMacBook-Pro:atlas lqk$ quick_start.py 
 
log4j:WARN No such property [maxFileSize] in org.apache.log4j.PatternLayout.
 
log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.PatternLayout.
 
log4j:WARN No such property [maxFileSize] in org.apache.log4j.PatternLayout.
 
log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.PatternLayout.
 
log4j:WARN No such property [maxFileSize] in org.apache.log4j.PatternLayout.
 
Enter username for atlas :- admin
 
Enter password for atlas :- 
 


 
Creating sample types: 
 
Created type [DB]
 
Created type [Table]
 
Created type [StorageDesc]
 
Created type [Column]
 
Created type [LoadProcess]
 
Created type [View]
 
Created type [JdbcAccess]
 
Created type [ETL]
 
Created type [Metric]
 
Created type [PII]
 
Created type [Fact]
 
Created type [Dimension]
 
Created type [Log Data]
 


 
Creating sample entities: 
 
Created entity of type [DB], guid: 6cc9fb57-f7c6-4865-8a2f-e98659f258c2
 
Created entity of type [DB], guid: d81edfe6-dd77-458a-b10f-89616ca0ab86
 
Created entity of type [DB], guid: e35465d2-eedc-444d-82aa-a35aaef1b06d
 
Created entity of type [StorageDesc], guid: ca0b4c96-6897-46fb-8af5-62833bba3810
 
Created entity of type [Column], guid: cb4b449f-f111-4279-bf08-c1f00ef09c55
 
Created entity of type [Column], guid: 2c2975cf-3499-4c13-b6d8-35ba5f3a51d3
 
Created entity of type [Column], guid: d4acb38e-4c28-49f4-aaa2-4f1aea6caf2b
 
Created entity of type [Column], guid: 044cdf47-d381-45bf-bd32-f5567a4e8268
 
Created entity of type [Column], guid: 7590459a-97a5-4dc0-9392-0fe0596bd44e
 
Created entity of type [Column], guid: 0b87045a-3b09-47ad-b927-3112eed9c9f7
 
Created entity of type [Column], guid: 4f750009-1468-42a3-91d5-2fa525ee6679
 
Created entity of type [Column], guid: 31d0768d-737c-468d-9a88-07e2bd91db9a
 
Created entity of type [Column], guid: 8243ae93-5b8e-42bd-8446-285e6d77781c
 
Created entity of type [Column], guid: 61f5bdfb-d112-4f14-8baa-2827787cf531
 
Created entity of type [Column], guid: 482af884-ec19-46bf-a056-582f0c6aa670
 
Created entity of type [Column], guid: f282ca8b-acca-4a0a-bcce-729a003cb9c6
 
Created entity of type [Column], guid: 6acda549-c2fb-46e8-87ee-b1942439c930
 
Created entity of type [Column], guid: 53c2725b-2a40-4949-989f-30f7f6af6a55
 
Created entity of type [Column], guid: a54d7f50-e1c7-45d5-aad1-fc55ce828eaa
 
Created entity of type [Column], guid: a3c82ffa-a5bd-47b4-bbb3-e14d33a883ad
 
Created entity of type [Column], guid: 15ca3700-e192-4f43-abd0-34f2795cd12f
 
Created entity of type [Table], guid: 47202943-1e81-4376-9425-282e400c0b4d
 
Created entity of type [Table], guid: a448aaf5-9e8e-49c4-8a57-156324db55e3
 
Created entity of type [Table], guid: 0cdc721d-164a-4b47-8833-823c3398aceb
 
Created entity of type [Table], guid: c1694204-5310-4dbf-9d8c-6c4f5f2f3262
 
Created entity of type [Table], guid: 630aafe8-372a-4c9f-bc29-02c44d298ba0
 
Created entity of type [Table], guid: 03dff79b-39e0-40da-964d-2092073bccc4
 
Created entity of type [Table], guid: 1949a001-1000-4840-8d7d-a8360817d4ed
 
Created entity of type [Table], guid: 7ccaa48d-c302-47fe-961d-facb91d90994
 
Created entity of type [View], guid: 2b3f7a84-f95e-4285-bc7a-c9b6fb4bb1e5
 
Created entity of type [View], guid: f072c2cc-d5f8-4a1e-bdb2-89cdbf9bbcbe
 
Created entity of type [LoadProcess], guid: e8c12cc2-07f5-4ae9-9f24-5f4eed34a08f
 
Created entity of type [LoadProcess], guid: 9d1917c9-647d-403e-8932-b2c96213b725
 
Created entity of type [LoadProcess], guid: e8158d40-6cda-48b3-a4c2-ab3030426171
 


 
Sample DSL Queries: 
 
Exception in thread "main" org.apache.atlas.AtlasServiceException: Metadata service API org.apache.atlas.AtlasClientV2$API_V2@2f953efd failed with status 500 (Internal Server Error) Response Body ({"errorCode":"ATLAS-500-00-004","errorMessage":"Discovery query failed from DB"})
 
	at org.apache.atlas.AtlasBaseClient.callAPIWithResource(AtlasBaseClient.java:389)
 
	at org.apache.atlas.AtlasBaseClient.callAPIWithResource(AtlasBaseClient.java:322)
 
	at org.apache.atlas.AtlasBaseClient.callAPI(AtlasBaseClient.java:238)
 
	at org.apache.atlas.AtlasClientV2.dslSearchWithParams(AtlasClientV2.java:346)
 
	at org.apache.atlas.examples.QuickStartV2.search(QuickStartV2.java:508)
 
	at org.apache.atlas.examples.QuickStartV2.runQuickstart(QuickStartV2.java:147)
 
	at org.apache.atlas.examples.QuickStartV2.main(QuickStartV2.java:126)
 
No sample data added to Apache Atlas Server.

Re: why quick_start.py error and how to clear all the data.

Posted by Ayub Khan Pathan <ap...@hortonworks.com>.
Hi,

If it is ok to remove all the metadata from Atlas and start from scratch. Follow below steps.


  1.  Stop Atlas
  2.  Start hbase shell and fire below commands
     *   disable ‘atlas_titan’ – This will disable the atlas_titan table where atlas stores all its metadata.
     *   drop ‘atlas_titan’ – This will drop the table.
  3.  Restart Atlas
This should actually remove all the existing types from backend store(hbase) and bring up atlas with clean state.

Regards
Ayub Khan

From: doom <43...@qq.com>
Reply-To: "user@atlas.apache.org" <us...@atlas.apache.org>
Date: Monday, December 11, 2017 at 3:14 PM
To: user <us...@atlas.apache.org>
Subject: why quick_start.py error and how to clear all the data.


hi all.

I use the git embedded-hbase-solr version.



when run quick_start.py it throws exception, how to fix it.

and after the exception, i re-run the quick_start.py, will

failed with status 409 (Conflict) Response Body ({"errorCode":"ATLAS-409-00-001","errorMessage":"Given type Dimension already exists"})

how to clear all the data.





FynndeMacBook-Pro:atlas lqk$ quick_start.py

log4j:WARN No such property [maxFileSize] in org.apache.log4j.PatternLayout.

log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.PatternLayout.

log4j:WARN No such property [maxFileSize] in org.apache.log4j.PatternLayout.

log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.PatternLayout.

log4j:WARN No such property [maxFileSize] in org.apache.log4j.PatternLayout.

Enter username for atlas :- admin

Enter password for atlas :-



Creating sample types:

Created type [DB]

Created type [Table]

Created type [StorageDesc]

Created type [Column]

Created type [LoadProcess]

Created type [View]

Created type [JdbcAccess]

Created type [ETL]

Created type [Metric]

Created type [PII]

Created type [Fact]

Created type [Dimension]

Created type [Log Data]



Creating sample entities:

Created entity of type [DB], guid: 6cc9fb57-f7c6-4865-8a2f-e98659f258c2

Created entity of type [DB], guid: d81edfe6-dd77-458a-b10f-89616ca0ab86

Created entity of type [DB], guid: e35465d2-eedc-444d-82aa-a35aaef1b06d

Created entity of type [StorageDesc], guid: ca0b4c96-6897-46fb-8af5-62833bba3810

Created entity of type [Column], guid: cb4b449f-f111-4279-bf08-c1f00ef09c55

Created entity of type [Column], guid: 2c2975cf-3499-4c13-b6d8-35ba5f3a51d3

Created entity of type [Column], guid: d4acb38e-4c28-49f4-aaa2-4f1aea6caf2b

Created entity of type [Column], guid: 044cdf47-d381-45bf-bd32-f5567a4e8268

Created entity of type [Column], guid: 7590459a-97a5-4dc0-9392-0fe0596bd44e

Created entity of type [Column], guid: 0b87045a-3b09-47ad-b927-3112eed9c9f7

Created entity of type [Column], guid: 4f750009-1468-42a3-91d5-2fa525ee6679

Created entity of type [Column], guid: 31d0768d-737c-468d-9a88-07e2bd91db9a

Created entity of type [Column], guid: 8243ae93-5b8e-42bd-8446-285e6d77781c

Created entity of type [Column], guid: 61f5bdfb-d112-4f14-8baa-2827787cf531

Created entity of type [Column], guid: 482af884-ec19-46bf-a056-582f0c6aa670

Created entity of type [Column], guid: f282ca8b-acca-4a0a-bcce-729a003cb9c6

Created entity of type [Column], guid: 6acda549-c2fb-46e8-87ee-b1942439c930

Created entity of type [Column], guid: 53c2725b-2a40-4949-989f-30f7f6af6a55

Created entity of type [Column], guid: a54d7f50-e1c7-45d5-aad1-fc55ce828eaa

Created entity of type [Column], guid: a3c82ffa-a5bd-47b4-bbb3-e14d33a883ad

Created entity of type [Column], guid: 15ca3700-e192-4f43-abd0-34f2795cd12f

Created entity of type [Table], guid: 47202943-1e81-4376-9425-282e400c0b4d

Created entity of type [Table], guid: a448aaf5-9e8e-49c4-8a57-156324db55e3

Created entity of type [Table], guid: 0cdc721d-164a-4b47-8833-823c3398aceb

Created entity of type [Table], guid: c1694204-5310-4dbf-9d8c-6c4f5f2f3262

Created entity of type [Table], guid: 630aafe8-372a-4c9f-bc29-02c44d298ba0

Created entity of type [Table], guid: 03dff79b-39e0-40da-964d-2092073bccc4

Created entity of type [Table], guid: 1949a001-1000-4840-8d7d-a8360817d4ed

Created entity of type [Table], guid: 7ccaa48d-c302-47fe-961d-facb91d90994

Created entity of type [View], guid: 2b3f7a84-f95e-4285-bc7a-c9b6fb4bb1e5

Created entity of type [View], guid: f072c2cc-d5f8-4a1e-bdb2-89cdbf9bbcbe

Created entity of type [LoadProcess], guid: e8c12cc2-07f5-4ae9-9f24-5f4eed34a08f

Created entity of type [LoadProcess], guid: 9d1917c9-647d-403e-8932-b2c96213b725

Created entity of type [LoadProcess], guid: e8158d40-6cda-48b3-a4c2-ab3030426171



Sample DSL Queries:

Exception in thread "main" org.apache.atlas.AtlasServiceException: Metadata service API org.apache.atlas.AtlasClientV2$API_V2@2f953efd failed with status 500 (Internal Server Error) Response Body ({"errorCode":"ATLAS-500-00-004","errorMessage":"Discovery query failed from DB"})

at org.apache.atlas.AtlasBaseClient.callAPIWithResource(AtlasBaseClient.java:389)

at org.apache.atlas.AtlasBaseClient.callAPIWithResource(AtlasBaseClient.java:322)

at org.apache.atlas.AtlasBaseClient.callAPI(AtlasBaseClient.java:238)

at org.apache.atlas.AtlasClientV2.dslSearchWithParams(AtlasClientV2.java:346)

at org.apache.atlas.examples.QuickStartV2.search(QuickStartV2.java:508)

at org.apache.atlas.examples.QuickStartV2.runQuickstart(QuickStartV2.java:147)

at org.apache.atlas.examples.QuickStartV2.main(QuickStartV2.java:126)

No sample data added to Apache Atlas Server.