lens-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tao Yan <t...@linkedin.com>
Subject Re: Lens Metadata Issues
Date Mon, 29 Aug 2016 20:41:38 GMT
Done. https://issues.apache.org/jira/browse/LENS-1301

On Mon, Aug 29, 2016 at 12:49 AM, Rajat Khandelwal <rajatgupta59@gmail.com>
wrote:

> Tao
>
> Please raise a jira for this at https://issues.apache.org/jira/browse/LENS
>
> On Sat, Aug 27, 2016 at 11:08 PM Tao Yan <tyan@linkedin.com> wrote:
>
>> Hi Lens Developers,
>>
>> I found some issues with Lens metadata. For example, I tried to create a
>> dimtable and failed, but Lens will create the metadata for the table. And
>> when I try to create it again, it complains 'table already exist', but I
>> cannot drop this dimtable until I run 'show dimtables'.
>>
>>
>> *lens-shell>create dimtable ***/schemas/dimension1_table3.xml*
>> *failed*
>>
>> *lens-shell>show dimtables*
>> *...*
>> *dimension1_division2*
>> *dimension1_table3*
>>
>> *lens-shell>drop dimtable dimension1_table3*
>> *succeeded*
>>
>> *-----------------------------*
>>
>> *lens-shell>create dimtable
>> /export/home/dev_svc/lens/schemas/dimension1_table3.xml*
>> *failed*
>>
>> *lens-shell>drop dimtable dimension1_table3*
>> *failed*
>>
>> *lens-shell>show dimtables*
>> *...*
>> *dimension1_division2*
>> *dimension1_table3*
>>
>> *lens-shell>drop dimtable dimension1_table3*
>> *succeeded*
>>
>>
>> *Dimension definition:*
>> <x_dimension name="dimension1" xmlns="uri:lens:cube:0.1" xmlns:xsi="
>> http://www.w3.org/2001/XMLSchema-instance"
>>   xsi:schemaLocation="uri:lens:cube:0.1 cube-0.1.xsd ">
>>   <attributes>
>>     <dim_attribute name="primary_key" _type="BIGINT"/>
>>     <dim_attribute name="attr1" _type="BIGINT"/>
>>     <dim_attribute name="attr2" _type="BIGINT"/>
>>     <dim_attribute name="attr3" _type="BIGINT"/>
>>     <dim_attribute name="attr4" _type="BIGINT"/>
>>     <dim_attribute name="attr5" _type="BIGINT"/>
>>     <dim_attribute name="attr6" _type="BIGINT"/>
>>     <dim_attribute name="attr7" _type="BIGINT"/>
>>     <dim_attribute name="attr8" _type="BIGINT"/>
>>   </attributes>
>>   <properties>
>>     <property name="dimension.dimension1.timed.dimension" value="dt"/>
>>   </properties>
>> </x_dimension>
>>
>> *Dimtable definition:*
>> <x_dimension_table dimension_name="dimension1"
>> table_name="dimension1_table3" weight="5.0" xmlns="uri:lens:cube:0.1"
>>   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> xsi:schemaLocation="uri:lens:cube:0.1 cube-0.1.xsd ">
>>   <columns>
>>     <column name="primary_key" _type="BIGINT"/>
>>     <column name="attr1" _type="BIGINT"/>
>>     <column name="attr5" _type="BIGINT"/>
>>   </columns>
>>   <properties>
>>     <property name="dimension1.prop" value="t3"/>
>>   </properties>
>>   <storage_tables>
>>     <storage_table>
>>       <update_periods>
>>         <update_period>HOURLY</update_period>
>>       </update_periods>
>>       <storage_name>mysql</storage_name>
>>       <table_desc external="true">
>>       </table_desc>
>>     </storage_table>
>>   </storage_tables>
>> </x_dimension_table>
>>
>> Thanks,
>> --
>>
>> *Tao Yan*
>> Software Engineer
>> Data Analytics Infrastructure Tools and Services
>>
>>
>>
>> 206.250.5345
>> tyan@linkedin.com
>> https://www.linkedin.com/in/taousc
>>
>


-- 

*Tao Yan*
Software Engineer
Data Analytics Infrastructure Tools and Services



206.250.5345
tyan@linkedin.com
https://www.linkedin.com/in/taousc

Mime
View raw message