Re: Support SI at Segment level

2021-03-22 Thread akashrn5
Hi, +1 for the feature. This is very important to improve query perf instead of waiting for SI and main table to e always in sync. I have reviewed the doc and given comments, please handle and please discuss with @venu Si as datamap feature to be inline as informed earlier. P.S: This design

Re: [DISCUSSION] Support alter schema for complex types

2021-03-22 Thread akashrn5
Hi, +1 for feature. Thanks for proposing it as now most of the use case from user perspective involves complex columns. I have reviewed the doc and given comments, please work on it, then can be reviewed again. Regards, Akash R -- Sent from:

Re: [Discussion]Presto Queries leveraging Secondary Index

2021-03-22 Thread VenuReddy
Hi all.! As discussed in the community meeting held on last week of Feb 2021, we already have plan to make Secondary Index as a Coarse Grain Datamap in the future. And It would be more appropriate for this requirement to implement Secondary Index as the CG Datamap. Presto query can leverage

Re: [DISCUSSION] Describe complex columns

2021-03-22 Thread akashrn5
Hi, +1 for the new functionality. my suggestion is to modify the DDL something like below DESCRIBE column fieldname ON [db_name.]table_name; DESCRIBE table short/transient [db_name.]table_name; Others can give their suggestions Thanks, Regards, Akash R -- Sent from:

Re: [DISCUSSION] Support alter schema for complex types

2021-03-22 Thread Indhumathi
+1. It is an important feature needs to be supported. Since, you have mentioned alter drop struct child column, are you gonna handle below scenarios also in phase 1? 1. support rename/change struct primitive child members ? 2. add new primitive child members in an existing struct ? If so,

Re: [DISCUSSION] Describe complex columns

2021-03-22 Thread VenuReddy
+1 Nice idea. It improves the readibility. Regards, Venu -- Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/

Re: [DISCUSSION] Describe complex columns

2021-03-22 Thread Indhumathi
+1. Please update design, for Map type having more than one level of complex types. For example, map> Regards, Indhumathi M -- Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/

[DISCUSSION] Support JOIN query with spatial index

2021-03-22 Thread Indhumathi
Hi community, Currently, carbon supports IN_POLYGON and IN_POLYGON_LIST udf's, where user has to manually provide the polygon points(series of latitude and longitude pair), to query carbon table based on spatial index. This feature will support JOIN tables based on IN_POLYGON udf filter,

Re: [DISCUSSION] Describe complex columns

2021-03-22 Thread Kunal Kapoor
+1 good idea for visualizing complex columns On Thu, Mar 18, 2021 at 10:35 PM Shreelekhya wrote: > Hi, > > Currently describe formatted displays the column information of a table and > some additional information. When complex types such as ARRAY, STRUCT, and > MAP types are present in table,