Analysisexception catalog namespace is not supported. - Oct 16, 2020 · I'm trying to load parquet file stored in hdfs. This is my schema: name type ----- ID BIGINT point SMALLINT check TINYINT What i want to execute is: df = sqlContext.read.parquet...

 
create table if not exists map_table like position_map_view; While using this it is giving me operation not allowed error. Bensussen deutsch and associates

Oct 4, 2019 · 4 Answers Sorted by: 45 I found AnalysisException defined in pyspark.sql.utils. https://spark.apache.org/docs/3.0.1/api/python/_modules/pyspark/sql/utils.html import pyspark.sql.utils try: spark.sql (query) print ("Query executed") except pyspark.sql.utils.AnalysisException: print ("Unable to process your query dude!!") Share Improve this answer Solution. Do one of the following: Upgrade the Hive metastore to version 2.3.0. This also resolves problems due to any other Hive bug that is fixed in version 2.3.0. Import the following notebook to your workspace and follow the instructions to replace the datanucleus-rdbms JAR. This notebook is written to upgrade the metastore to version 2.1.1.For now we went with a manual route where we build hive 1.2.1 with the patch which enables glue catalog. Used the above hive distribution to build the aws-glue-catalog client for spark and used the same version of hive to build a distribution of spark 3.x. This new spark 3.x distribution we build works like a charm with the aws-glue-spark-clientMar 23, 2016 · 1 Answer. Sorted by: 2. To be able to store text in your language you have to use nchar or nvarchar data type, which support UNICODE. See: nchar and nvarchar (Transact-SQL) Do not forget to use proper collation. See: Collation and Unicode Support. So, a column name (varchar (50)) should be name (nvarchar (50)), then. I'm running EMR cluster with the 'AWS Glue Data Catalog as the Metastore for Hive' option enable. Connecting through a Spark Notebook working fine e.g spark.sql("show databases") spark.catalog.setC...Unity Catalog is supported on clusters that run Databricks Runtime 11.3 LTS or above. Unity Catalog is supported by default on all SQL warehouse compute versions. Clusters running on earlier versions of Databricks Runtime do not provide support for all Unity Catalog GA features and functionality.Error in SQL statement: AnalysisException: cannot resolve ' a.COUNTRY_ID ' given input columns: [a."PK_LOYALTYACCOUNT";"COUNTRY_ID";"CDC_TYPE", b."PK_LOYALTYACCOUNT";"COUNTRY_ID";"CDC_TYPE"]; line 7 pos 7; I know the code works as I have successfully run the code on my SQL Server The code is as follows:go to folder options - > view tab -> and clear the Hide extensions for known file types checkbox. now change the file extension from constr.txt to constr.udl. double click on constr.udl. select the provider as sql from provider tab. enter server name , userid , password and database name in connection tab. and click on test connection button to ...We are using Spark-sql and Parquet data-format. Avro is used as the schema format. We are trying to use “aliases” on field names and are running into issues while trying to use alias-name in SELECT. Sample schema, where each field has both a name and a alias: { "namespace": "com.test.profile", ...The ANALYZE TABLE command does not support views. CATALOG_OPERATION. Catalog <catalogName> does not support <operation>. COMBINATION_QUERY_RESULT_CLAUSES. Combination of ORDER BY/SORT BY/DISTRIBUTE BY/CLUSTER BY. COMMENT_NAMESPACE. Attach a comment to the namespace <namespace>. CREATE_TABLE_STAGING_LOCATION. Create a catalog table in a staging ...For now we went with a manual route where we build hive 1.2.1 with the patch which enables glue catalog. Used the above hive distribution to build the aws-glue-catalog client for spark and used the same version of hive to build a distribution of spark 3.x. This new spark 3.x distribution we build works like a charm with the aws-glue-spark-clientJun 1, 2018 · Exception in thread "main" org.apache.spark.sql.AnalysisException: Operation not allowed: ALTER TABLE RECOVER PARTITIONS only works on table with location provided: `db`.`resultTable`; Note: Altough the error, it created a table with the correct columns. It also created partitions and the table has a location with Parquet files in it (/user ... Jun 21, 2021 · 0. I'm trying to add multiple spark catalog in spark 3.x and I have a question: Does spark support a feature that allows us to use multiple catalog managed by namespace like this: spark.sql.catalog.<ns1>.conf1=... spark.sql.catalog.<ns1>.conf2=... spark.sql.catalog.<ns2>.conf1=... spark.sql.catalog.<ns2>.conf2=... Hi @Kaniz, Seems like DLT dotn talk to unity catolog currently. So , we are thinking either develop while warehouse at DLT or catalog. But I guess DLT dont have data lineage option and catolog dont have change data feed ( cdc - change data capture ) .2 Answers. Sorted by: 1. According to the official documentation of Databricks about LOAD DATA (highlighting's mine): Loads the data into a Hive SerDe table from the user specified directory or file. According to the exception message (highlighting's mine) you use a Spark SQL table ( datasource table ): AnalysisException: LOAD DATA is not ...Sep 22, 2022 · Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question.Provide details and share your research! But avoid …. Asking for help, clarification, or responding to other answers. I am trying to create a delta live table in Unity Catalog as follows: CREATE OR REFRESH STREAMING LIVE TABLE <catalog>.<db>.<table_name> AS . SELECT ... However, I get the error: org.apache.spark.sql.AnalysisException: Unsupported SQL statement for table Multipart table names is not supported. Are DLTs not supported with Unity Catalog yet?May 16, 2022 · Solution. Do one of the following: Upgrade the Hive metastore to version 2.3.0. This also resolves problems due to any other Hive bug that is fixed in version 2.3.0. Import the following notebook to your workspace and follow the instructions to replace the datanucleus-rdbms JAR. This notebook is written to upgrade the metastore to version 2.1.1. We have deployed the Databricks RDB loader (version 4.2.1) with a Databricks cluster (DBR 9.1 LTS). Both are up, running and talking to each other and we can see the manifest table has been created correctly. We can also see queries being submitted to the cluster in the SparkUI. However, once the manifest has been created the RDB Loader runs SHOW columns in hive_metastore.snowplow_schema ...THANK YOU! This is the answer that keeps on giving. I am using Vectornator to create my SVG files and it outputs a lot of vectornator:layerName So, I went through and every time I found a colon that wasn't in a URL, but was naming something, I changed it to camelCase (like vectornatorLayerName) and the SVG works now!Overview. Kudu has tight integration with Apache Impala, allowing you to use Impala to insert, query, update, and delete data from Kudu tablets using Impala’s SQL syntax, as an alternative to using the Kudu APIs to build a custom Kudu application. In addition, you can use JDBC or ODBC to connect existing or new applications written in any ...The column was not included in the select list of a subquery. The column has been renamed using the table alias or column alias. The column reference is correlated, and you did not specify LATERAL. The column reference is to an object that is not visible because it appears earlier in the same select list or within a scalar subquery. MitigationNov 3, 2022 · Azure Synapse Lake Database - Notebook cannot access information_schema. In Synapse Analytics I can write the following SQL script and it works fine: And it throws the error: Error: spark_catalog requires a single-part namespace, but got [dataverse_blob_blob, information_schema] Tried using USE CATALOG and USE SCHEMA to set the catalog/schema ... For now we went with a manual route where we build hive 1.2.1 with the patch which enables glue catalog. Used the above hive distribution to build the aws-glue-catalog client for spark and used the same version of hive to build a distribution of spark 3.x. This new spark 3.x distribution we build works like a charm with the aws-glue-spark-clientRelated Question add prefix to spark rdd elements AnalysisException callUDF() inside withColumn() Spark DataFrame AnalysisException add parent name prefix to dataframe structtype fields add parent column name as prefix to avoid ambiguity add prefix or sufix in nifi tailFile processor AnalysisException when loading a PipelineModel with Spark 3 ...I have used catalog name as my_catalog , database I have created with name db and table name I have given is sampletable , though when I run the job it fails with below error: AnalysisException: The namespace in session catalog must have exactly one name part: my_catalog.db.sampletableQuerying with SQL 🔗. In Spark 3, tables use identifiers that include a catalog name. SELECT * FROM prod.db.table; -- catalog: prod, namespace: db, table: table. Metadata tables, like history and snapshots, can use the Iceberg table name as a namespace. For example, to read from the files metadata table for prod.db.table:In Spark 3.1 or earlier, the namespace field was named database for the builtin catalog, and there is no isTemporary field for v2 catalogs. To restore the old schema with the builtin catalog, you can set spark.sql.legacy.keepCommandOutputSchema to true . Spark Exception: There is no Credential Scope. I am new to Databricks and trying to connect to Rstudio Server from my all-purpose compute cluster. Here are the cluster configuration: Policy: Personal Compute Access mode: Single user Databricks run ... apache-spark. databricks. spark-ar-studio. databricks-unity-catalog. Oct 16, 2020 · I'm trying to load parquet file stored in hdfs. This is my schema: name type ----- ID BIGINT point SMALLINT check TINYINT What i want to execute is: df = sqlContext.read.parquet... This will be implemented the future versions using Spark 3.0. To create a Delta table, you must write out a DataFrame in Delta format. An example in Python being. df.write.format ("delta").save ("/some/data/path") Here's a link to the create table documentation for Python, Scala, and Java. Share. Improve this answer.Apr 22, 2020 · 1 Answer. I tried, pls refer to below SQL - this will work in impala. Only issue i can see is, if hearing_evaluation has multiple patient ids for a given patient id, you need to de-duplicate the data. There can be case when patient id doesnt exist in image table - in such case you need to apply RIGHT JOIN. We have deployed the Databricks RDB loader (version 4.2.1) with a Databricks cluster (DBR 9.1 LTS). Both are up, running and talking to each other and we can see the manifest table has been created correctly. We can also see queries being submitted to the cluster in the SparkUI. However, once the manifest has been created the RDB Loader runs SHOW columns in hive_metastore.snowplow_schema ...May 22, 2020 · I'm running EMR cluster with the 'AWS Glue Data Catalog as the Metastore for Hive' option enable. Connecting through a Spark Notebook working fine e.g spark.sql("show databases") spark.catalog.setCurrentDatabase(<databasename>) spark.sql... Jul 21, 2023 · CREATE CATALOG [ IF NOT EXISTS ] <catalog-name> [ MANAGED LOCATION '<location-path>' ] [ COMMENT <comment> ]; For example, to create a catalog named example: CREATE CATALOG IF NOT EXISTS example; Assign privileges to the catalog. See Unity Catalog privileges and securable objects. Python. Run the following SQL command in a notebook. Mar 23, 2021 · User class threw exception: org.apache.spark.sql.AnalysisException: java.lang.RuntimeException: java.io.IOException: Unable to create directory /tmp/hive/. We run Spark 2.3.2 on Hadoop 3.1.1. We use external ORC tables stored on HDFS. We are encountering an issue on a job run under CRON when issuing the command `sql ("msck repair table db.some ... I am trying to create a delta live table in Unity Catalog as follows: CREATE OR REFRESH STREAMING LIVE TABLE <catalog>.<db>.<table_name> AS . SELECT ... However, I get the error: org.apache.spark.sql.AnalysisException: Unsupported SQL statement for table Multipart table names is not supported. Are DLTs not supported with Unity Catalog yet?when I amend the code to: args = parser.parse_args('') I got the below error: AttributeError: 'Namespace' object has no attribute 'encodings' but if I made like your code without (''): args = parser.parse_args() I got the below error: An exception has occurred, use %tb to see the full traceback.See full list on learn.microsoft.com I have not worked with spark.catalog yet but looking at the source code here, looks like the options kwarg is only used when schema is not provided. if schema is None: df = self._jcatalog.createTable(tableName, source, description, options). It doesnot look like they are using that kwarg for partitioning –For example, a function catalog that loads functions using reflection and uses Java packages as namespaces is not required to support the methods to create, alter, or drop a namespace. Implementations are allowed to discover the existence of objects or namespaces without throwing NoSuchNamespaceException when no namespace is found.Teams. Q&A for work. Connect and share knowledge within a single location that is structured and easy to search. Learn more about TeamsException in thread "main" org.apache.spark.sql.AnalysisException: Operation not allowed: ALTER TABLE RECOVER PARTITIONS only works on table with location provided: `db`.`resultTable`; Note: Altough the error, it created a table with the correct columns. It also created partitions and the table has a location with Parquet files in it (/user ...I'm still not understanding how one would reference a table that requires a database or schema qualifier. This call to createOrReplaceTempView was supposed to replace registerTempTable however functionality changed in that we are no longer able to specify where in the database the table lives.Syntax { USE | SET } CATALOG [ catalog_name | ' catalog_name ' ] Parameter catalog_name Name of the catalog to use. If the catalog does not exist, an exception is thrown. Examples SQLI have used catalog name as my_catalog , database I have created with name db and table name I have given is sampletable , though when I run the job it fails with below error: AnalysisException: The namespace in session catalog must have exactly one name part: my_catalog.db.sampletableJun 1, 2018 · Exception in thread "main" org.apache.spark.sql.AnalysisException: Operation not allowed: ALTER TABLE RECOVER PARTITIONS only works on table with location provided: `db`.`resultTable`; Note: Altough the error, it created a table with the correct columns. It also created partitions and the table has a location with Parquet files in it (/user ... We are using Spark-sql and Parquet data-format. Avro is used as the schema format. We are trying to use “aliases” on field names and are running into issues while trying to use alias-name in SELECT. Sample schema, where each field has both a name and a alias: { "namespace": "com.test.profile", ...Jul 17, 2020 · For now we went with a manual route where we build hive 1.2.1 with the patch which enables glue catalog. Used the above hive distribution to build the aws-glue-catalog client for spark and used the same version of hive to build a distribution of spark 3.x. This new spark 3.x distribution we build works like a charm with the aws-glue-spark-client Nov 12, 2021 · I didn't find an easy way of getting CREATE TABLE LIKE to work, but I've got a workaround. On DBR in Databricks you should be able to use SHALLOW CLONE to do something similar: Returned not the time of moments ignored; The past is a ruling you can’t argue: Make time for times that memory will store. Think back to the missed and regret will pour. But now you know all that you should have knew: When there are no more, a moment’s worth more. Events gathered then now play an encore When eyelids dark dive. Thankful are ... For example, a function catalog that loads functions using reflection and uses Java packages as namespaces is not required to support the methods to create, alter, or drop a namespace. Implementations are allowed to discover the existence of objects or namespaces without throwing NoSuchNamespaceException when no namespace is found. See full list on learn.microsoft.com Drop a table in the catalog and completely remove its data by skipping a trash even if it is supported. If the catalog supports views and contains a view for the identifier and not a table, this must not drop the view and must return false. If the catalog supports to purge a table, this method should be overridden.The ANALYZE TABLE command does not support views. CATALOG_OPERATION. Catalog <catalogName> does not support <operation>. COMBINATION_QUERY_RESULT_CLAUSES. Combination of ORDER BY/SORT BY/DISTRIBUTE BY/CLUSTER BY. COMMENT_NAMESPACE. Attach a comment to the namespace <namespace>. CREATE_TABLE_STAGING_LOCATION. Create a catalog table in a staging ...I'm trying to load parquet file stored in hdfs. This is my schema: name type ----- ID BIGINT point SMALLINT check TINYINT What i want to execute is: df = sqlContext.read.parquet...Catalog implementations are not required to maintain the existence of namespaces independent of objects in a namespace. For example, a function catalog that loads functions using reflection and uses Java packages as namespaces is not required to support the methods to create, alter, or drop a namespace. Implementations are allowed to discover ... I have used catalog name as my_catalog , database I have created with name db and table name I have given is sampletable , though when I run the job it fails with below error: AnalysisException: The namespace in session catalog must have exactly one name part: my_catalog.db.sampletable You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window.I have not worked with spark.catalog yet but looking at the source code here, looks like the options kwarg is only used when schema is not provided. if schema is None: df = self._jcatalog.createTable(tableName, source, description, options). It doesnot look like they are using that kwarg for partitioning –Not supported in Unity Catalog: ... NAMESPACE_NOT_EMPTY, NAMESPACE_NOT_FOUND, ... Operation not supported in READ ONLY session mode.Dec 29, 2020 · 2 Answers. Sorted by: 1. According to the official documentation of Databricks about LOAD DATA (highlighting's mine): Loads the data into a Hive SerDe table from the user specified directory or file. According to the exception message (highlighting's mine) you use a Spark SQL table ( datasource table ): AnalysisException: LOAD DATA is not ... If the catalog supports views and contains a view for the old identifier and not a table, this throws NoSuchTableException. Additionally, if the new identifier is a table or a view, this throws TableAlreadyExistsException. If the catalog does not support table renames between namespaces, it throws UnsupportedOperationException. The column was not included in the select list of a subquery. The column has been renamed using the table alias or column alias. The column reference is correlated, and you did not specify LATERAL. The column reference is to an object that is not visible because it appears earlier in the same select list or within a scalar subquery. MitigationI'm still not understanding how one would reference a table that requires a database or schema qualifier. This call to createOrReplaceTempView was supposed to replace registerTempTable however functionality changed in that we are no longer able to specify where in the database the table lives.Teams. Q&A for work. Connect and share knowledge within a single location that is structured and easy to search. Learn more about TeamsA catalog is created and named by adding a property spark.sql.catalog.(catalog-name) with an implementation class for its value. Iceberg supplies two implementations: org.apache.iceberg.spark.SparkCatalog supports a Hive Metastore or a Hadoop warehouse as a catalogDec 29, 2020 · 2 Answers. Sorted by: 1. According to the official documentation of Databricks about LOAD DATA (highlighting's mine): Loads the data into a Hive SerDe table from the user specified directory or file. According to the exception message (highlighting's mine) you use a Spark SQL table ( datasource table ): AnalysisException: LOAD DATA is not ... AWS specific options. Provide the following option only if you choose cloudFiles.useNotifications = true and you want Auto Loader to set up the notification services for you: Option. cloudFiles.region. Type: String. The region where the source S3 bucket resides and where the AWS SNS and SQS services will be created.Dec 14, 2022 · [0m18:33:42.551967 [debug] [Thread-1 (]: Databricks adapter: diagnostic-info: org.apache.hive.service.cli.HiveSQLException: Error running query: org.apache.spark.sql.AnalysisException: Catalog namespace is not supported. Apr 1, 2019 · EDIT: as a first step, if you just wanted to check which columns have whitespace, you could use something like the following: space_cols = [column for column in df.columns if re.findall ('\s*', column) != []] Also, check whether there are any characters that are non-alphanumeric (or space): Aug 10, 2023 · To enable Unity Catalog when you create a workspace: As an account admin, log in to the account console. Click Workspaces. Click the Enable Unity Catalog toggle. Select the Metastore. On the confirmation dialog, click Enable. Complete the workspace creation configuration and click Save. I'm trying to load parquet file stored in hdfs. This is my schema: name type ----- ID BIGINT point SMALLINT check TINYINT What i want to execute is: df = sqlContext.read.parquet...Note: REPLACE TABLE AS SELECT is only supported with v2 tables. Apache Spark’s DataSourceV2 API for data source and catalog implementations. Spark DSv2 is an evolving API with different levels of support in Spark versions: As per my repro, it works well with Databricks Runtime 8.0 version. For more details, refer:Enter a name for the group. Click Confirm. When prompted, add users to the group. Add a user or group to a workspace, where they can perform data science, data engineering, and data analysis tasks using the data managed by Unity Catalog: In the sidebar, click Workspaces. On the Permissions tab, click Add permissions.Aug 30, 2023 · The ANALYZE TABLE command does not support views. CATALOG_OPERATION. Catalog <catalogName> does not support <operation>. COMBINATION_QUERY_RESULT_CLAUSES. Combination of ORDER BY/SORT BY/DISTRIBUTE BY/CLUSTER BY. COMMENT_NAMESPACE. Attach a comment to the namespace <namespace>. CREATE_TABLE_STAGING_LOCATION. Create a catalog table in a staging ... Syntax { USE | SET } CATALOG [ catalog_name | ' catalog_name ' ] Parameter catalog_name Name of the catalog to use. If the catalog does not exist, an exception is thrown. Examples SQLCatalog implementations are not required to maintain the existence of namespaces independent of objects in a namespace. For example, a function catalog that loads functions using reflection and uses Java packages as namespaces is not required to support the methods to create, alter, or drop a namespace. Implementations are allowed to discover ...I was using Azure Databricks and trying to run some example python code from this page. But I get this exception: py4j.security.Py4JSecurityException: Constructor public org.apache.spark.ml.Oct 4, 2019 · 4 Answers Sorted by: 45 I found AnalysisException defined in pyspark.sql.utils. https://spark.apache.org/docs/3.0.1/api/python/_modules/pyspark/sql/utils.html import pyspark.sql.utils try: spark.sql (query) print ("Query executed") except pyspark.sql.utils.AnalysisException: print ("Unable to process your query dude!!") Share Improve this answer Not supported in Unity Catalog: ... NAMESPACE_NOT_EMPTY, NAMESPACE_NOT_FOUND, ... Operation not supported in READ ONLY session mode.Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question.Provide details and share your research! But avoid …. Asking for help, clarification, or responding to other answers.

Dec 14, 2022 · [0m18:33:42.551967 [debug] [Thread-1 (]: Databricks adapter: diagnostic-info: org.apache.hive.service.cli.HiveSQLException: Error running query: org.apache.spark.sql.AnalysisException: Catalog namespace is not supported. . Gpt classifier

analysisexception catalog namespace is not supported.

May 31, 2021 · org.apache.spark.sql.AnalysisException ALTER TABLE CHANGE COLUMN is not supported for changing column 'bam_user' with type 'IntegerType' to 'bam_user' with type 'StringType' apache-spark delta-lake Not supported in Unity Catalog: ... NAMESPACE_NOT_EMPTY, NAMESPACE_NOT_FOUND, ... Operation not supported in READ ONLY session mode.Apr 16, 2012 · go to folder options - > view tab -> and clear the Hide extensions for known file types checkbox. now change the file extension from constr.txt to constr.udl. double click on constr.udl. select the provider as sql from provider tab. enter server name , userid , password and database name in connection tab. and click on test connection button to ... We are using Spark-sql and Parquet data-format. Avro is used as the schema format. We are trying to use “aliases” on field names and are running into issues while trying to use alias-name in SELECT. Sample schema, where each field has both a name and a alias: { "namespace": "com.test.profile", ...AnalysisException: [UC_COMMAND_NOT_SUPPORTED] Spark higher-order functions are not supported in Unity Catalog.; I'm using a shared cluster with 12.2 LTS Databricks Runtime and unity catalog is enabled.I'm trying to load parquet file stored in hdfs. This is my schema: name type ----- ID BIGINT point SMALLINT check TINYINT What i want to execute is: df = sqlContext.read.parquet...For now we went with a manual route where we build hive 1.2.1 with the patch which enables glue catalog. Used the above hive distribution to build the aws-glue-catalog client for spark and used the same version of hive to build a distribution of spark 3.x. This new spark 3.x distribution we build works like a charm with the aws-glue-spark-clientNov 25, 2022 · 2 Answers Sorted by: 6 I found the problem. I had used access mode None, when it needs Single user or Shared. To create a cluster that can access Unity Catalog, the workspace you are creating the cluster in must be attached to a Unity Catalog metastore and must use a Unity-Catalog-capable access mode (shared or single user). Enter a name for the group. Click Confirm. When prompted, add users to the group. Add a user or group to a workspace, where they can perform data science, data engineering, and data analysis tasks using the data managed by Unity Catalog: In the sidebar, click Workspaces. On the Permissions tab, click Add permissions.Aug 29, 2023 · Not supported in Unity Catalog: ... NAMESPACE_NOT_EMPTY, NAMESPACE_NOT_FOUND, ... Operation not supported in READ ONLY session mode. Enter a name for the group. Click Confirm. When prompted, add users to the group. Add a user or group to a workspace, where they can perform data science, data engineering, and data analysis tasks using the data managed by Unity Catalog: In the sidebar, click Workspaces. On the Permissions tab, click Add permissions.1 Answer. I tried, pls refer to below SQL - this will work in impala. Only issue i can see is, if hearing_evaluation has multiple patient ids for a given patient id, you need to de-duplicate the data. There can be case when patient id doesnt exist in image table - in such case you need to apply RIGHT JOIN.Drop a table in the catalog and completely remove its data by skipping a trash even if it is supported. If the catalog supports views and contains a view for the identifier and not a table, this must not drop the view and must return false. If the catalog supports to purge a table, this method should be overridden. Get Started Discussions. Get Started Resources. Databricks Platform. Databricks Platform Discussions. Warehousing & Analytics. Administration & Architecture. Community Cove. Community News & Member Recognition. Databricks..

Popular Topics