You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Ibrahim Acet <ib...@widas.de> on 2011/12/09 10:04:46 UTC
nested JSON structures
Hi,
I was wondering if there is a possibility in HIVE to handle nested JSON
structures.
I tried get_json_object and json_tuple but could not achieve any
<http://www.dict.cc/englisch-deutsch/results.html> results.
Thanks
Re: nested JSON structures
Posted by Jason Rutherglen <ja...@gmail.com>.
Roberto,
Do you have an example of using your project with HBase?
Thanks!
On Fri, Dec 9, 2011 at 9:29 AM, Roberto Congiu <ro...@openx.com> wrote:
> I wrote a SerDe that can handle nested structures.
>
> https://github.com/rcongiu
>
> Roberto
>
>
> On Fri, Dec 9, 2011 at 7:42 AM, Ibrahim Acet <ib...@widas.de> wrote:
>>
>> Hi,
>>
>> are there any tutorials available for custom UDF creation ?
>>
>>
>>
>> thx
>>
>>
>>
>> Von: Edward Capriolo [mailto:edlinuxguru@gmail.com]
>> Gesendet: Freitag, 9. Dezember 2011 16:22
>> An: user@hive.apache.org
>> Betreff: Re: nested JSON structures
>>
>>
>>
>> Hive does have some JSON capabilities. To handle nested structures like
>> this I have wrtten custom UDFs that return structs and then use LATERAL VIEW
>> and explode on them.
>>
>>
>>
>>
>> http://www.slideshare.net/edwardcapriolo/breaking-firstnormal-form-with-hive
>>
>>
>>
>> On Fri, Dec 9, 2011 at 10:06 AM, Ibrahim Acet <ib...@widas.de>
>> wrote:
>>
>> Hi,
>>
>> with nested json I mean something like this:
>>
>>
>>
>> {"success": "true", "message": "", "total": "1", "data":
>>
>> {
>>
>> "id": "0001",
>>
>> "type": "donut",
>>
>> "name": "Cake",
>>
>> "ppu": 0.55,
>>
>> "batters":
>>
>> {
>>
>> "batter":
>>
>> [
>>
>> { "id": "1001", "type": "Regular" },
>>
>> { "id": "1002", "type": "Chocolate"
>> },
>>
>> { "id": "1003", "type": "Blueberry"
>> },
>>
>> { "id": "1004", "type": "Devil's
>> Food" }
>>
>> ]
>>
>> },
>>
>> "topping":
>>
>> [
>>
>> { "id": "5001", "type": "None" },
>>
>> { "id": "5002", "type": "Glazed" },
>>
>> { "id": "5005", "type": "Sugar" },
>>
>> { "id": "5007", "type": "Powdered Sugar" },
>>
>> { "id": "5006", "type": "Chocolate with Sprinkles"
>> },
>>
>> { "id": "5003", "type": "Chocolate" },
>>
>> { "id": "5004", "type": "Maple" }
>>
>> ]
>>
>> }
>>
>> }
>>
>> I need to extract all the information.
>>
>>
>>
>> Thx
>>
>>
>>
>> Von: Paul Mackles [mailto:pmackles@adobe.com]
>> Gesendet: Freitag, 9. Dezember 2011 15:43
>> An: user@hive.apache.org
>> Betreff: RE: nested JSON structures
>>
>>
>>
>> What exactly do you mean by “nested json structures”? If the built-ins
>> don’t work you can always write a UDF.
>>
>>
>>
>> From: Ibrahim Acet [mailto:ibrahim.acet@widas.de]
>> Sent: Friday, December 09, 2011 4:05 AM
>> To: user@hive.apache.org
>> Subject: nested JSON structures
>>
>>
>>
>> Hi,
>>
>> I was wondering if there is a possibility in HIVE to handle nested JSON
>> structures.
>>
>> I tried get_json_object and json_tuple but could not achieve any results.
>>
>>
>>
>> Thanks
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
>> Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
>> Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
>>
>>
>>
>> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
>> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
>> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
>> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
>> Weitergabe dieser Mail sind nicht gestattet.
>>
>>
>>
>> This e- mail may contain confidential and/or privileged information. If
>> you are not the intended recipient (or have received this e-mail in error)
>> please notify the sender immediately and destroy this e-mail. Any
>> unauthorized copying, disclosure or distribution of the material in this
>> e-mail is strictly forbidden.
>>
>>
>>
>>
>>
>>
>>
>> Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
>> Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
>> Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
>>
>>
>>
>> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
>> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
>> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
>> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
>> Weitergabe dieser Mail sind nicht gestattet.
>>
>>
>>
>> This e- mail may contain confidential and/or privileged information. If
>> you are not the intended recipient (or have received this e-mail in error)
>> please notify the sender immediately and destroy this e-mail. Any
>> unauthorized copying, disclosure or distribution of the material in this
>> e-mail is strictly forbidden.
>>
>>
>>
>>
>>
>>
>>
>>
>> Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
>> Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
>> Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
>>
>>
>>
>> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
>> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
>> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
>> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
>> Weitergabe dieser Mail sind nicht gestattet.
>>
>>
>>
>> This e- mail may contain confidential and/or privileged information. If
>> you are not the intended recipient (or have received this e-mail in error)
>> please notify the sender immediately and destroy this e-mail. Any
>> unauthorized copying, disclosure or distribution of the material in this
>> e-mail is strictly forbidden.
>>
>>
>
Re: nested JSON structures
Posted by Roberto Congiu <ro...@openx.com>.
I wrote a SerDe that can handle nested structures.
https://github.com/rcongiu
Roberto
On Fri, Dec 9, 2011 at 7:42 AM, Ibrahim Acet <ib...@widas.de> wrote:
> Hi, ****
>
> are there any tutorials available for custom UDF creation ?****
>
> ** **
>
> thx****
>
> ** **
>
> *Von:* Edward Capriolo [mailto:edlinuxguru@gmail.com]
> *Gesendet:* Freitag, 9. Dezember 2011 16:22
> *An:* user@hive.apache.org
> *Betreff:* Re: nested JSON structures****
>
> ** **
>
> Hive does have some JSON capabilities. To handle nested structures like
> this I have wrtten custom UDFs that return structs and then use LATERAL
> VIEW and explode on them.****
>
> ** **
>
>
> http://www.slideshare.net/edwardcapriolo/breaking-firstnormal-form-with-hive
> ****
>
> ** **
>
> On Fri, Dec 9, 2011 at 10:06 AM, Ibrahim Acet <ib...@widas.de>
> wrote:****
>
> Hi, ****
>
> with nested json I mean something like this:****
>
> ****
>
> {"success": "true", "message": "", "total": "1", "data":****
>
> {****
>
> "id": "0001",****
>
> "type": "donut",****
>
> "name": "Cake",****
>
> "ppu": 0.55,****
>
> "batters":****
>
> {****
>
> "batter":****
>
> [****
>
> { "id": "1001", "type": "Regular" },
> ****
>
> { "id": "1002", "type": "Chocolate"
> },****
>
> { "id": "1003", "type": "Blueberry"
> },****
>
> { "id": "1004", "type": "Devil's
> Food" }****
>
> ]****
>
> },****
>
> "topping":****
>
> [****
>
> { "id": "5001", "type": "None" },****
>
> { "id": "5002", "type": "Glazed" },****
>
> { "id": "5005", "type": "Sugar" },****
>
> { "id": "5007", "type": "Powdered Sugar" },****
>
> { "id": "5006", "type": "Chocolate with Sprinkles"
> },****
>
> { "id": "5003", "type": "Chocolate" },****
>
> { "id": "5004", "type": "Maple" }****
>
> ]****
>
> }****
>
> }****
>
> I need to extract all the information.****
>
> ****
>
> Thx ****
>
> ****
>
> *Von:* Paul Mackles [mailto:pmackles@adobe.com]
> *Gesendet:* Freitag, 9. Dezember 2011 15:43
> *An:* user@hive.apache.org
> *Betreff:* RE: nested JSON structures****
>
> ****
>
> What exactly do you mean by “nested json structures”? If the built-ins
> don’t work you can always write a UDF.****
>
> ****
>
> *From:* Ibrahim Acet [mailto:ibrahim.acet@widas.de]
> *Sent:* Friday, December 09, 2011 4:05 AM
> *To:* user@hive.apache.org
> *Subject:* nested JSON structures****
>
> ****
>
> Hi, ****
>
> I was wondering if there is a possibility in HIVE to handle nested JSON
> structures.****
>
> I tried get_json_object and json_tuple but could not achieve any results.*
> ***
>
> ****
>
> Thanks ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
> Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
> Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
> ****
>
> ****
>
> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
> Weitergabe dieser Mail sind nicht gestattet.****
>
> ****
>
> This e- mail may contain confidential and/or privileged information. If
> you are not the intended recipient (or have received this e-mail in error)
> please notify the sender immediately and destroy this e-mail. Any
> unauthorized copying, disclosure or distribution of the material in this
> e-mail is strictly forbidden.****
>
> ****
>
> ** **
>
> ****
>
> Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
> Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
> Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
> ****
>
> ****
>
> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
> Weitergabe dieser Mail sind nicht gestattet.****
>
> ****
>
> This e- mail may contain confidential and/or privileged information. If
> you are not the intended recipient (or have received this e-mail in error)
> please notify the sender immediately and destroy this e-mail. Any
> unauthorized copying, disclosure or distribution of the material in this
> e-mail is strictly forbidden.****
>
> ** **
>
> ** **
>
> **
>
>
>
> Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
> Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
> Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
>
>
>
> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
> Weitergabe dieser Mail sind nicht gestattet.
>
>
>
> This e- mail may contain confidential and/or privileged information. If
> you are not the intended recipient (or have received this e-mail in error)
> please notify the sender immediately and destroy this e-mail. Any
> unauthorized copying, disclosure or distribution of the material in this
> e-mail is strictly forbidden.
>
>
AW: nested JSON structures
Posted by Ibrahim Acet <ib...@widas.de>.
Hi,
are there any tutorials available for custom UDF creation ?
thx
Von: Edward Capriolo [mailto:edlinuxguru@gmail.com]
Gesendet: Freitag, 9. Dezember 2011 16:22
An: user@hive.apache.org
Betreff: Re: nested JSON structures
Hive does have some JSON capabilities. To handle nested structures like
this I have wrtten custom UDFs that return structs and then use LATERAL
VIEW and explode on them.
http://www.slideshare.net/edwardcapriolo/breaking-firstnormal-form-with-hi
ve
On Fri, Dec 9, 2011 at 10:06 AM, Ibrahim Acet <ib...@widas.de>
wrote:
Hi,
with nested json I mean something like this:
{"success": "true", "message": "", "total": "1", "data":
{
"id": "0001",
"type": "donut",
"name": "Cake",
"ppu": 0.55,
"batters":
{
"batter":
[
{ "id": "1001", "type": "Regular" },
{ "id": "1002", "type": "Chocolate"
},
{ "id": "1003", "type": "Blueberry"
},
{ "id": "1004", "type": "Devil's
Food" }
]
},
"topping":
[
{ "id": "5001", "type": "None" },
{ "id": "5002", "type": "Glazed" },
{ "id": "5005", "type": "Sugar" },
{ "id": "5007", "type": "Powdered Sugar" },
{ "id": "5006", "type": "Chocolate with Sprinkles"
},
{ "id": "5003", "type": "Chocolate" },
{ "id": "5004", "type": "Maple" }
]
}
}
I need to extract all the information.
Thx
Von: Paul Mackles [mailto:pmackles@adobe.com]
Gesendet: Freitag, 9. Dezember 2011 15:43
An: user@hive.apache.org
Betreff: RE: nested JSON structures
What exactly do you mean by nested json structures? If the built-ins
dont work you can always write a UDF.
From: Ibrahim Acet [mailto:ibrahim.acet@widas.de]
Sent: Friday, December 09, 2011 4:05 AM
To: user@hive.apache.org
Subject: nested JSON structures
Hi,
I was wondering if there is a possibility in HIVE to handle nested JSON
structures.
I tried get_json_object and json_tuple but could not achieve any results.
Thanks
Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail sind nicht gestattet.
This e- mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail sind nicht gestattet.
This e- mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
Re: nested JSON structures
Posted by Edward Capriolo <ed...@gmail.com>.
Hive does have some JSON capabilities. To handle nested structures like
this I have wrtten custom UDFs that return structs and then use LATERAL
VIEW and explode on them.
http://www.slideshare.net/edwardcapriolo/breaking-firstnormal-form-with-hive
On Fri, Dec 9, 2011 at 10:06 AM, Ibrahim Acet <ib...@widas.de> wrote:
> Hi,
>
> with nested json I mean something like this:
>
>
>
> {"success": "true", "message": "", "total": "1", "data":
>
> {
>
> "id": "0001",
>
> "type": "donut",
>
> "name": "Cake",
>
> "ppu": 0.55,
>
> "batters":
>
> {
>
> "batter":
>
> [
>
> { "id": "1001", "type": "Regular" },
>
> { "id": "1002", "type": "Chocolate"
> },
>
> { "id": "1003", "type": "Blueberry"
> },
>
> { "id": "1004", "type": "Devil's
> Food" }
>
> ]
>
> },
>
> "topping":
>
> [
>
> { "id": "5001", "type": "None" },
>
> { "id": "5002", "type": "Glazed" },
>
> { "id": "5005", "type": "Sugar" },
>
> { "id": "5007", "type": "Powdered Sugar" },
>
> { "id": "5006", "type": "Chocolate with Sprinkles"
> },
>
> { "id": "5003", "type": "Chocolate" },
>
> { "id": "5004", "type": "Maple" }
>
> ]
>
> }
>
> }
>
> I need to extract all the information.
>
>
>
> Thx
>
>
>
> *Von:* Paul Mackles [mailto:pmackles@adobe.com]
> *Gesendet:* Freitag, 9. Dezember 2011 15:43
> *An:* user@hive.apache.org
> *Betreff:* RE: nested JSON structures
>
>
>
> What exactly do you mean by “nested json structures”? If the built-ins
> don’t work you can always write a UDF.
>
>
>
> *From:* Ibrahim Acet [mailto:ibrahim.acet@widas.de]
> *Sent:* Friday, December 09, 2011 4:05 AM
> *To:* user@hive.apache.org
> *Subject:* nested JSON structures
>
>
>
> Hi,
>
> I was wondering if there is a possibility in HIVE to handle nested JSON
> structures.
>
> I tried get_json_object and json_tuple but could not achieve any results.
>
>
>
> Thanks
>
>
>
>
>
>
>
>
>
> Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
> Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
> Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
>
>
>
> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
> Weitergabe dieser Mail sind nicht gestattet.
>
>
>
> This e- mail may contain confidential and/or privileged information. If
> you are not the intended recipient (or have received this e-mail in error)
> please notify the sender immediately and destroy this e-mail. Any
> unauthorized copying, disclosure or distribution of the material in this
> e-mail is strictly forbidden.
>
>
>
>
>
> Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
> Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
> Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
>
>
>
> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
> Weitergabe dieser Mail sind nicht gestattet.
>
>
>
> This e- mail may contain confidential and/or privileged information. If
> you are not the intended recipient (or have received this e-mail in error)
> please notify the sender immediately and destroy this e-mail. Any
> unauthorized copying, disclosure or distribution of the material in this
> e-mail is strictly forbidden.
>
>
AW: nested JSON structures
Posted by Ibrahim Acet <ib...@widas.de>.
Hi,
with nested json I mean something like this:
{"success": "true", "message": "", "total": "1", "data":
{
"id": "0001",
"type": "donut",
"name": "Cake",
"ppu": 0.55,
"batters":
{
"batter":
[
{ "id": "1001", "type": "Regular" },
{ "id": "1002", "type": "Chocolate"
},
{ "id": "1003", "type": "Blueberry"
},
{ "id": "1004", "type": "Devil's
Food" }
]
},
"topping":
[
{ "id": "5001", "type": "None" },
{ "id": "5002", "type": "Glazed" },
{ "id": "5005", "type": "Sugar" },
{ "id": "5007", "type": "Powdered Sugar" },
{ "id": "5006", "type": "Chocolate with Sprinkles"
},
{ "id": "5003", "type": "Chocolate" },
{ "id": "5004", "type": "Maple" }
]
}
}
I need to extract all the information.
Thx
Von: Paul Mackles [mailto:pmackles@adobe.com]
Gesendet: Freitag, 9. Dezember 2011 15:43
An: user@hive.apache.org
Betreff: RE: nested JSON structures
What exactly do you mean by nested json structures? If the built-ins
dont work you can always write a UDF.
From: Ibrahim Acet [mailto:ibrahim.acet@widas.de]
Sent: Friday, December 09, 2011 4:05 AM
To: user@hive.apache.org
Subject: nested JSON structures
Hi,
I was wondering if there is a possibility in HIVE to handle nested JSON
structures.
I tried get_json_object and json_tuple but could not achieve any results.
Thanks
Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail sind nicht gestattet.
This e- mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
RE: nested JSON structures
Posted by Paul Mackles <pm...@adobe.com>.
What exactly do you mean by "nested json structures"? If the built-ins don't work you can always write a UDF.
From: Ibrahim Acet [mailto:ibrahim.acet@widas.de]
Sent: Friday, December 09, 2011 4:05 AM
To: user@hive.apache.org
Subject: nested JSON structures
Hi,
I was wondering if there is a possibility in HIVE to handle nested JSON structures.
I tried get_json_object and json_tuple but could not achieve any results<http://www.dict.cc/englisch-deutsch/results.html>.
Thanks
Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer: Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim, Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail sind nicht gestattet.
This e- mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.